In this assignment, you only need to copy and paste the statements from SQL deve

Question

In this assignment, you only need to copy and paste the statements from SQL developer or SQLPlus.
Note: You run the following three sql statements ONCE each (ignore error messages) before you perform the tasks in the order they appear.

CREATE TABLE regions
as select * from hr.regions;

CREATE TABLE locations
as select * from hr.locations;

CREATE TABLE departments
as select * from hr.departments;

Recreate the Departments table in your account based on hr.departments table. However, your Departments table only has the data for the departments with the department names ending with ‘ion’ or ‘Sales’.

Explanation / Answer

CREATE TABLE departments

as SELECT * FROM hr.departments WHERE name LIKE '%ion' OR name LIKE '%Sales'

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects