Search notes:

Oracle SQL noun: TABLE

The Oracle SQL statements with the noun table are

alter table
analyze table
create table
drop table
flashback table
lock table
purge table
truncate table

alter table add column

alter table … add … adds a column to a table.

The default clause allows to specify a value with which the new column is filled.

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;

Github repository Oracle-Patterns, path: /DatabaseObjects/Tables/AlterTable/add_column.sql

alter table rename column

alter table … rename column … allows to rename a column in a table, as is demonstrated in the following simple example:

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;

Github repository Oracle-Patterns, path: /DatabaseObjects/Tables/AlterTable/rename_column.sql

move compress where

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

Oracle SQL noun: TABLE

alter table add column

alter table rename column

move compress where

See also