CREATE TABLE emp ( 
   empno    INTEGER, 
   ename    VARCHAR(20), 
   job      VARCHAR(20), 
   mgr      INTEGER, 
   hiredate DATE, 
   sal      DECIMAL(7,2), 
   comm1    DECIMAL(7,2), 
   dept	    INTEGER; 
begin 
insert into emp values (1,'JOHNSON','ADMIN',6,'1990-12-
17',18000,NULL,4); 
insert into emp values (2,'HARDING','MANAGER',9,'1998-
02-02',52000,300,3); 
insert into emp values (3,'TAFT','SALES I',2,'1996-01-
02',25000,500,3); 
insert into emp values (4,'HOOVER','SALES I',2,'1990-04-
02',27000,NULL,3); 
insert into emp values (5,'LINCOLN','TECH',6,'1994-06-
23',22500,1400,4); 
insert into emp values (6,'GARFIELD','MANAGER',9,'1993-
05-01',54000,NULL,4); 
insert into emp values (7,'HARRISON','TECH',6,'1997-09-
22',25000,NULL,4); 
insert into emp values (8,'GRANT','ENGINEER',10,'1997-
03-30',32000,NULL,2); 
insert into emp values (9,'JACKSON','CEO',NULL,'1990-01-
01',75000,NULL,4); 
insert into emp values (10,'FILLMORE','MANAGER',9,'1994-
08-09',56000,NULL,2); 
insert into emp values (11,'ADAMS','ENGINEER',10,'1996-
03-15',34000,NULL,2); 
insert into emp values (12,'WASHINGTON','ADMIN',6,'1998-
04-16',18000,NULL,4); 
insert into emp values (13,'MONROE','ENGINEER',10,'2000-
12-03',30000,NULL,2); 
insert into emp values (14,'ROOSEVELT','CPA',9,'1995-10-
12',35000,NULL,1); 
end; 
/ 
CREATE TABLE dept ( 
   deptno INTEGER, 
   dname  VARCHAR(14), 
   loc    VARCHAR(13)); 
begin 
insert into dept values (1,'ACCOUNTING','ST LOUIS'); 
insert into dept values (2,'RESEARCH','NEW YORK'); 
insert into dept values (3,'SALES','ATLANTA'); 
insert into dept values (4,'OPERATIONS','SEATTLE'); 
end; 
/