DECLAREBEGINinsert into deptvalues(10, 'ACCOUNTING', 'NEW YORK');insert into deptvalues(20, 'RESEARCH', 'DALLAS');insert into deptvalues(30, 'SALES', 'CHICAGO');insert into deptvalues(40, 'OPERATIONS', 'BOSTON');insert into empvalues(7839, 'KING', 'PRESIDENT', null,to_date('17-11-1981','dd-mm-yyyy'),5000, null, 10);insert into empvalues(7698, 'BLAKE', 'MANAGER', 7839,to_date('1-5-1981','dd-mm-yyyy'),2850, null, 30);insert into empvalues(7782, 'CLARK', 'MANAGER', 7839,to_date('9-6-1981','dd-mm-yyyy'),2450, null, 10);insert into emp
values(7566, 'JONES', 'MANAGER', 7839,to_date('2-4-1981','dd-mm-yyyy'),2975, null, 20);insert into empvalues(7788, 'SCOTT', 'ANALYST', 7566,to_date('9-12-1981','dd-mm-yyyy'),3000, null, 20);insert into empvalues(7902, 'FORD', 'ANALYST', 7566,to_date('3-12-1981','dd-mm-yyyy'),3000, null, 20);insert into empvalues(7369, 'SMITH', 'CLERK', 7902,to_date('17-12-1980','dd-mm-yyyy'),800, null, 20);insert into empvalues(7499, 'ALLEN', 'SALESMAN', 7698,to_date('20-2-1981','dd-mm-yyyy'),1600, 300, 30);insert into empvalues(7521, 'WARD', 'SALESMAN', 7698,to_date('22-2-1981','dd-mm-yyyy'),1250, 500, 30);insert into empvalues(7654, 'MARTIN', 'SALESMAN', 7698,to_date('28-9-1981','dd-mm-yyyy'),1250, 1400, 30);insert into empvalues(7844, 'TURNER', 'SALESMAN', 7698,to_date('8-9-1981','dd-mm-yyyy'),1500, 0, 30);insert into empvalues(7876, 'ADAMS', 'CLERK', 7788,to_date('12-1-1983', 'dd-mm-yyyy'),1100, null, 20);insert into emp
values(7900, 'JAMES', 'CLERK', 7698,to_date('3-12-1981','dd-mm-yyyy'),950, null, 30);insert into empvalues(7934, 'MILLER', 'CLERK', 7782,to_date('23-1-1982','dd-mm-yyyy'),1300, null, 10);/*insert into salgradevalues (1, 700, 1200);insert into salgradevalues (2, 1201, 1400);insert into salgradevalues (3, 1401, 2000);insert into salgradevalues (4, 2001, 3000);insert into salgradevalues (5, 3001, 9999);*/COMMIT;END;