employees, regions, countries, locations, departments, jobs, job_grades, job_history table creation and data
Disclaimer: All credits go to the creator of this script…
create table employees
(employee_id NUMBER(6) CONSTRAINT employees_employee_id_pk PRIMARY KEY,
first_name varchar2(20),
last_name varchar2(25) CONSTRAINT employees_last_name_nn NOT NULL,
email varchar2(25) CONSTRAINT employees_email_nn NOT NULL,
phone_number varchar2(20),
hire_date date CONSTRAINT employees_hire_date_nn NOT NULL,
job_id varchar2(10) CONSTRAINT employees_job_id_nn NOT NULL,
salary number(8,2),
commission_pct number(2,2),
manager_id number(6),
department_id number(4));
