Oracle SQL noun: TABLE

alter table add column

create table tq84_table (
  col_1 number,
  col_2 date
);

desc tq84_table;

insert into tq84_table values (1, sysdate);

alter table tq84_table add ( col_3 varchar2(10));
alter table tq84_table add ( col_4 number, col_5 number);
alter table tq84_table add ( col_6 number default 7);

desc tq84_table;

select * from tq84_table;

drop table tq84_table purge;

alter table rename column

create table tq84_table (
  col_1 number,
  col_2 date
);

insert into tq84_table values (1, sysdate);

alter table tq84_table rename column col_1 to nm;
alter table tq84_table rename column col_2 to dt;

desc tq84_table;

select * from tq84_table;

drop table tq84_table purge;

move compress where

alter table xyz move
   compress
   including rows
   where
     trx_dt < date '2019-01-01';

See also