EMP

CREATE TABLE EMP

(EMPNO int NOT NULL,

ENAME VARCHAR(10),

JOB VARCHAR(9),

MGR int,

HIREDATE DATE,

SAL double(7, 2),

COMM double(7, 2),

DEPTNO int);

INSERT INTO EMP VALUES

(7369, 'SMITH',? 'CLERK',? ? 7902,

str_to_date('17-DEC-1980', '%e-%M-%Y'),? 800, NULL, 20);

INSERT INTO EMP VALUES

(7499, 'ALLEN',? 'SALESMAN',? 7698,

str_to_date('20-FEB-1981', '%e-%M-%Y'), 1600,? 300, 30);

INSERT INTO EMP VALUES

(7521, 'WARD',? 'SALESMAN',? 7698,

str_to_date('22-FEB-1981', '%e-%M-%Y'), 1250,? 500, 30);

INSERT INTO EMP VALUES

(7566, 'JONES',? 'MANAGER',? 7839,

str_to_date('2-APR-1981', '%e-%M-%Y'),? 2975, NULL, 20);

INSERT INTO EMP VALUES

(7654, 'MARTIN', 'SALESMAN',? 7698,

str_to_date('28-SEP-1981', '%e-%M-%Y'), 1250, 1400, 30);

INSERT INTO EMP VALUES

(7698, 'BLAKE',? 'MANAGER',? 7839,

str_to_date('1-MAY-1981', '%e-%M-%Y'),? 2850, NULL, 30);

INSERT INTO EMP VALUES

(7782, 'CLARK',? 'MANAGER',? 7839,

str_to_date('9-JUN-1981','%e-%M-%Y'),? 2450, NULL, 10);

INSERT INTO EMP VALUES

(7788, 'SCOTT',? 'ANALYST',? 7566,

str_to_date('09-DEC-1982','%e-%M-%Y'), 3000, NULL, 20);

INSERT INTO EMP VALUES

(7839, 'KING',? 'PRESIDENT', NULL,

str_to_date('17-NOV-1981', '%e-%M-%Y'), 5000, NULL, 10);

INSERT INTO EMP VALUES

(7844, 'TURNER', 'SALESMAN',? 7698,

str_to_date('8-SEP-1981', '%e-%M-%Y'),? 1500,? ? 0, 30);

INSERT INTO EMP VALUES

(7876, 'ADAMS',? 'CLERK',? ? 7788,

str_to_date('12-JAN-1983', '%e-%M-%Y'), 1100, NULL, 20);

INSERT INTO EMP VALUES

(7900, 'JAMES',? 'CLERK',? ? 7698,

str_to_date('3-DEC-1981', '%e-%M-%Y'),? 950, NULL, 30);

INSERT INTO EMP VALUES

(7902, 'FORD',? 'ANALYST',? 7566,

str_to_date('3-DEC-1981', '%e-%M-%Y'),? 3000, NULL, 20);

INSERT INTO EMP VALUES

(7934, 'MILLER', 'CLERK',? ? 7782,

str_to_date('23-JAN-1982','%e-%M-%Y'), 1300, NULL, 10);

DEPT

CREATE TABLE DEPT

(DEPTNO integer,

DNAME VARCHAR(14),

LOC VARCHAR(13) );

INSERT INTO DEPT VALUES (10, 'ACCOUNTING', 'NEW YORK');

INSERT INTO DEPT VALUES (20, 'RESEARCH',? 'DALLAS');

INSERT INTO DEPT VALUES (30, 'SALES',? ? ? 'CHICAGO');

INSERT INTO DEPT VALUES (40, 'OPERATIONS', 'BOSTON');