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.
View Answer Bookmark Now

Create the table Department table based on the following table instance chart.
Column Name ID Name
Data Type NUMBER VARCHAR
Length 8 25
View Answer Bookmark Now
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
View Answer Bookmark Now
Drop table Employee and Department.
View Answer Bookmark Now