Computer Science
Add one column Email of data type VARCHAR and size 30 to the table Customer.
DDL & DML
4 Likes
Answer
ALTER TABLE Customer
ADD (Email VARCHAR(30)) ;
Answered By
3 Likes
Related Questions
Drop table Employee and Department.
Create table Customer as per following Table Instance Chart.
Column Name Data Type Length Cust_ID NUMBER 7 Cust_Name VARCHAR 30 Cust_Address1 VARCHAR 20 Cust_Address2 VARCHAR 30 Pincode NUMBER 6 Cust_Phone VARCHAR 10 Add one more column CustomerIncomeGroup of datatype VARCHAR(10).
Insert few records with relevant information, in the table.