Add a date type column to a table

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

Table created.

SQL>
SQL>  alter table bar add d date;

Table altered.

SQL>
SQL>  select object_type, status
  2      from user_objects
  3     where object_name = 'SHIELD'
  4    /

OBJECT_TYPE         STATUS
------------------- -------
PACKAGE             VALID
PACKAGE BODY        VALID

SQL>
SQL> drop table bar;

Table dropped.

SQL>

Related examples in the same category

1.	Add a char 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

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

Related examples in the same category