Pr.Pg Next Pg

Adding new column in the Table using Query tutorials

 

  • To add a column to an existing table, use the  ALTER TABLE...ADD statement.

  • The following statement alters the SUPPLIER  table to add a new column named CITY:

 

ALTER TABLE SUPPLIER

ADD ( CITY VARCHAR2(30));

 

  • From the above statement, CITY column is added in to the SUPPLIER table. Now Expand the SUPPLIER table

  • and review the updates.

 


Pr.Pg border                                              Next Pg