welcome 1
SQL EXPERIMENTS:- 1. Aim: The marketing company wishes to computerize its operations by using the following tables. producers:- 1.1. Create Table: `CLIENT_MASTER` and Insert Values CREATE TABLE CLIENT_MASTER ( CLIENT_NO VARCHAR2(6) PRIMARY KEY, NAME VARCHAR2(20) NOT NULL, ADDRESS1 VARCHAR2(30), ADDRESSS VARCHAR2(30), CITY VARCHAR2(15), PINCODE VARCHAR2(8), STATE VARCHAR2(15), BAL_DUE NUMBER(10,2) ); INSERT INTO CLIENT_MASTER VALUES ('C001', 'Rajesh', 'Street 1', 'Apartment 10', 'Mumbai', '400001', 'Maharashtra', 1500.50); INSERT INTO CLIENT_MASTER VALUES ('C002', 'Amit', 'Sector 9', 'Block A', 'Bangalore', '560001', 'Karnataka', 500.00); INSERT INTO CLIENT_MASTER VALUES ('C003', 'Priya', 'Main Road', 'House 22', 'Chennai', '600001', 'Tamil Nadu', 1200.75...
Comments
Post a Comment