Computer Science
Answer
INSERT INTO Customer (Cust_ID, Cust_Name, Cust_Address1, Cust_Address2, Pincode, Cust_Phone, Email, CustomerIncomeGroup)
VALUES
(11, 'Amit', '1st Main Street', 'Mumbai', 12345, '5551234121', 'amit@gmail.com', 'High'),
(24, 'Vidya', '4th Main Street', 'Bangalore', 54321, '5234325678', 'vidya24@gmail.com', 'Medium'),
(39, 'Amruta', '78th Main Street', 'Goa', 98765, '5976539012', 'amruta78@gmail.com', 'Low');
Related Questions
Add one column Email of data type VARCHAR and size 30 to the table Customer.
Add one more column CustomerIncomeGroup of datatype VARCHAR(10).
Drop the column CustomerIncomeGroup from table Customer.
Create table Department as per following Table Instance Chart.
Column Name DeptID DeptName Key Type Primary Nulls/Unique NOT NULL Datatype NUMBER VARCHAR Length 2 20