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

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

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

Answer

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).

Column Name	Data Type	Length
ID	NUMBER	8
First_Name	VARCHAR	25
Last_Name	VARCHAR	25
Dept_ID	NUMBER	8

Computer Science

Create table Customer as per following Table Instance Chart.Column NameData TypeLengthCust_IDNUMBER7Cust_NameVARCHAR30Cust_Address1VARCHAR20Cust_Address2VARCHAR30PincodeNUMBER6Cust_PhoneVARCHAR10

DDL & DML

Answer

Related Questions

Create the table Employee based on the following table instance chart.Column NameData TypeLengthIDNUMBER8First_NameVARCHAR25Last_NameVARCHAR25Dept_IDNUMBER8

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).

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

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