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

object_type status
------------------- -------
Package valid
Package Body Valid

Sql>
sql> drop table bar;

Table dropped.

Sql>

Give yourself an added field for a table

Sql>--Create demo table
Sql> CREATE TABLE Employee (
2 ID varchar2 (4 byte) not NULL,
3 first_name varchar2 (byte),
4 last_name varchar2 (byte),
5 start_date Date,
6 end_date Date,
7 Salary Number (8,2),
8 City Varchar2 (Byte),
9 Description varchar2 (MB)
10)
11/

Table created.