Computer Science
Populate the table Department with data from table dept. Including only required columns.
DDL & DML
7 Likes
Answer
INSERT INTO Department (ID, Name)
SELECT ID, Name
FROM dept ;
Answered By
4 Likes
Related Questions
Drop the table Empl.
Create the table Department table based on the following table instance chart.
Column Name ID Name Data Type NUMBER VARCHAR Length 8 25 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.