| |
GeekInterview.com > Interview Questions > Oracle > SQL
| Print | |
Question: How to add new column in the existing table at our desired location?
|
| September 09, 2008 04:06:21 |
#4 |
| mahato.neelima |
Member Since: September 2008 Total Comments: 2 |
RE: How to add new column in the existing table at our desired location?
|
Syntax : - Alter Table <table_name> ADD Column (<column_name1> <data_type1>[size1], <column_name2> <data_type2>[size2], ...);
Example : - Alter Table Employee ADD Column (Address2 Varchar2(28),Phone2 Number(6)); |
| |
Back To Question | |
