Computer Science
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 |
DDL & DML
1 Like
Answer
CREATE TABLE Employee (
ID NUMBER(8),
First_Name VARCHAR(25),
Last_Name VARCHAR(25),
Dept_ID NUMBER(8)
);
Answered By
1 Like
Related Questions
Create the table Department table based on the following table instance chart.
Column Name ID Name Data Type NUMBER VARCHAR Length 8 25 Populate the table Department with data from table dept. Including only required columns.
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