How to add a new column to the database

Syntax #1

How to add a new column to a the existing table

ALTER TABLE table_name
 ADD column_name column-definition;

EXAMPLES:

ALTER TABLE student
 ADD DOB  varchar2(10);

This will add a column called DOB to the student table. 

Syntax #2

How to add multiple columns to an existing table, the ALTER TABLE syntax is:

ALTER TABLE table_name
ADD ( column_1 column-definition,
  column_2 column-definition,
  ... 
  column_n column_definition );

EXAMPLES:

ALTER TABLE student
ADD ( DOB vvarchar2(10)
   AGE int ); 

* iOS Development * OS X * Product Review