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