create table PL_DEPT
(
DEPTNO NUMBER not null,
DNAME VARCHAR2(50),
LOC VARCHAR2(50)
)
create table PL_EMP
(
EMPNO NUMBER(4),
ENAME VARCHAR2(20),
JOB VARCHAR2(20),
MGR NUMBER(4),
HIREDATE DATE,
SAL NUMBER(20,3),
COMM NUMBER(4),
DEPTNO NUMBER(4)
)