CEG-COMPUTER SCIENCE DEPT - HOME

MODIFYING THE STRUCTURE OF TABLE. ADDING A NEW COLUMN. SQL> ALTER TABLE Emp252 . ADD (age number(3), phno number(10)); Table altered. MODIFYING EXISTING COLUMN. SQL> ALTER TABLE Emp252 . MODIFY (phno varchar(20)); Table altered. DROPING A COLUMN. SQL> ALTER TABLE Emp252 . DROP COLUMN phno; Table altered. QUERY FOR THE TABLE … ................
................