Oracle alter statement usage

Oracle alter statement usage

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>

Add a Date Field

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 = 'shields'
4/

Object_type status
--------------------------
Package valid
Package body valid

SQL>
SQL> drop table bar;

Table dropped.

SQL>

Add fields to tables

SQL> -- create demo table
SQL> create table employee (
2 id varchar2 (4 byte) not null,
3 first_name varchar2 (10 byte ),
4 last_name varchar2 (10 byte ),
5 start_date date,
6 end_date date,
7 salary number (8, 2 ),
8 city varchar2 (10 byte ),
9 description varchar2 (15 bytes)
10)
11/

Table created.