RDBMS LAB MANUAL Roll.No:1

To modify already exsisting column. Alter table department modify dloc varchar2(10); Table altered. Name Null? Type DNAME VARCHAR2(5) DNO NUMBER(4) DLOC VARCHAR2(10) DSPL VARCHAR2(5) 3. To delete a column. Alter table dept drop column dspl; Table altered. Name Null? ................
................

In order to avoid copyright disputes, this page is only a partial summary.