hi all here i got a nice article on alter statements:
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 );
For example:
ALTER TABLE supplier
ADD ( supplier_name varchar2(50),
city varchar2(45) );
This will add two columns (supplier_name and city) to the supplier table.
For More infromation Please visit this page:
http://www.techonthenet.com/sql/tables/alter_table.php
Enjoy Coding........
Bharath Reddy VasiReddy
|