Add a char type column to a table : Add Column « Table « Oracle PL / SQL






Add a char type column to a table

   
SQL>
SQL> create table bar ( n number );

Table created.

SQL>
SQL> alter table bar add c char(1);

Table altered.

SQL>
SQL> drop table bar;

Table dropped.

SQL>

   
    
  








Related examples in the same category

1.Add a date type column to a table
2.Alter table: add a column to an existing table
3.Add two columns to a table
4.Alter a table to add two columns and use select to check
5.Alter table to add two columns and then drop them
6.Alter table to add a column and then add constraint to it
7.Alter table to add a column and then add 'check' constraint to it
8.Alter table to add a primary key
9.Alter table to add varray type column
10.Alter table to add date type column
11.Add more columns
12.Add new column with default value and not null