PL/SQL LAB EXERCISES:
RDBMS QUESTIONS: DDL &DML COMMANDS: 1)(a) Create a table called Customer table Name Type Cust_name Varchar2(20) Cust_street Varchar2(20) Cust_city Varchar2(20) (i) Insert records into the table. (ii) Add salary column to the table. (iii) Alter the table column domain. (iv) Drop salary column of the customer table. (v) Delete the rows of customer table whose cust_city is “New York”. 2) (a) Create a table called Stock table Name Type Sid Number Sname Varchar2(20) Rating Varchar2(20) (i) Add column age to the Stock table. (ii) Insert values into the Stock table. (iii) Delete the row with Rating 8. (iv) Update the column details of Stock. (v) Insert null values into the table. 3) (a) Create a table called Branch table. Name Type Branch name Varchar2(20) Branch_city Varchar2(20) ...