Computer Science
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 |
DDL & DML
6 Likes
Answer
CREATE TABLE Customer (
Cust_ID NUMBER(7),
Cust_Name VARCHAR(30),
Cust_Address1 VARCHAR(20),
Cust_Address2 VARCHAR(30),
Pincode NUMBER(6),
Cust_Phone VARCHAR(10)
);
Answered By
2 Likes
Related Questions
Create the table Employee based on the following table instance chart.
Column Name Data Type Length ID NUMBER 8 First_Name VARCHAR 25 Last_Name VARCHAR 25 Dept_ID NUMBER 8 Drop table Employee and Department.
Add one column Email of data type VARCHAR and size 30 to the table Customer.
Add one more column CustomerIncomeGroup of datatype VARCHAR(10).