RDBMS LAB EXERCISES WITH ANSWER
EXERCISE:1 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”. 💠Step-by-step SQL Queries: ✅ (1) Create the Customer table SQL> CREATE TABLE Customer ( Cust_name VARCHAR2(20), Cust_street VARCHAR2(20), Cust_city VARCHAR2(20) ); ✅ (2) Insert records into the table SQL> INSERT INTO Customer (Cust_name, Cust_street, Cust_city) VALUES ('Alice', '1st Avenue', 'New York'); INSERT INTO Customer (Cust_name, Cust_street, Cust_city) VALUES ('Bob', '2nd Street', 'Los Angele...
Comments
Post a Comment