create table emp
(empno number,
empname varchar2(40),
dept_no number,
hiredate date,
active varchar2(1));

 create table dept(dept_no number,
 dept_name varchar2(40));