Alter Table

Syntax:-  1 alter table tablename add(newcolname datatype(Size),newcolname
datatype(size))
                 2 alter table tablename modify(colname newdatatype(size));
Ex:-           1 alter table vision add(pno number(5));
                  2 alter table vision modify(sal number(7));
The alter table command cannot perform the following tasks

• Change the name of the table
• Change the name of the column
• Drop a column
• Decrease the size of a column if table data exists

For
Online Classes

Contact Us: +919885348743