RDBMS LAB MANUAL Roll.No:1

SQL used by IBM/DB2 and DS Database Systems. SQL adopted as standard language for RDBS by ASNI in 1989. ... DSPL VARCHAR2(5) 2. 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 ... ................
................

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

Google Online Preview   Download