Run the preparation statements before you perform the tasks. Some students may see an error message saying the table doesnt exist, ignore it.

Drop table jobs cascade constraints;

Drop table employees cascade constraints;

Drop table accounts cascade constraints;

CREATE TABLE employees

as select * from hr.employees;

CREATE TABLE jobs

as select * from hr.jobs;

CREATE Table accounts (cust_fname varchar(20),

cust_lname varchar(20),

acc_open_date date,

balance number(20,2));

2. Import four columns (first_name, last_name, hire_date, salary) data from employees table into accounts table.