Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Tuesday, 3 October 2017

Add Column in Oracle Table



We can to add new column to existing table by altering table.
 
Syntax:
        Alter table <table_name> add <col  datatype>;
Example:
      ALTER TABLE student ADD phone NUMBER;



You can add more than one column in oracle table by using altering table

 

Syntax:
        Alter table <table_name> add (<col1  datatype>,<col2  datatype>);

Example:
 ALTER TABLE student ADD (phone1 NUMBER, email VARCHAR2(10) );


Share this article :

0 comments:

Post a Comment