CREATE TABLE employees(
employee_id NUMBER(6)
first_name VARCHAR2(20),
last_name VARCHAR2(25),
email VARCHAR2(25),
hire_date DATE,
job_id VARCHAR2(10),
manager_id NUMBER(6),
department_id NUMBER(4)
) ;
INSERT INTO employees (employee_id, first_name, last_name, email, hire_date, job_id, manager_id, department_id ) VALUES (100, 'King', 'kim', 'SKING', '14-FEB-2011', 'AD_PRES', 100, 90);
INSERT INTO employees (employee_id, first_name, last_name, email, hire_date, job_id, manager_id, department_id ) VALUES (101, 'Kochhar', 'choi', 'KOCH', '21-SEP-2015', 'AD_VP', 100, 90);
INSERT INTO employees (employee_id, first_name, last_name, email, hire_date, job_id, manager_id, department_id ) VALUES (102, 'Hann', 'pack', 'LDEH', '13-JAN-2017', 'AD_VP', 102, 90);
set linesize 130
col employee_id format 99999999
col first_name format a8
col last_name format a8
col email format a8
col hire_date format a11
col job_id format a11
col manager_id format 9999999
col department_id format 9999999
SELECT * FROM employees;