Add Column « Table « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Table
  3. Add Column
1.Add a char type column to a table
2.Add a date type column to a table
3.Alter table: add a column to an existing table
4.Add two columns to a table
5.Alter a table to add two columns and use select to check
6.Alter table to add two columns and then drop them
7.Alter table to add a column and then add constraint to it
8.Alter table to add a column and then add 'check' constraint to it
9.Alter table to add a primary key




10.Alter table to add varray type column
11.Alter table to add date type column
12.Add more columns
13.Add new column with default value and not null