insert into emp(empno,empname,dept_no,hiredate,active)
values (2490,'Dori',10,to_date('10-OCT-07'),'Y');

insert into emp(empno,empname,dept_no,hiredate,active)
values (2500,'Harry',20,to_date('10-MAY-08'),'Y');

insert into emp(empno,empname,dept_no,hiredate,active)
values (2501,'Rick',30,to_date('10-APR-08'),'Y');


insert into dept(dept_no,dept_name)
values(10,'ACC');

insert into dept(dept_no,dept_name)
values(20,'IT');

insert into dept(dept_no,dept_name)
values(30,'FIN');

commit;