Utworzenie tablicy;

create table emp1
  ( empno number(4) not null constraint emp_prim primary key,
    ename varchar2(10) check (ename=upper(ename)),
    job varchar2(10),
    hiredate date,
    ni_number varchar(12),
    sal number(7,2),
    deptno number(2) not null constraint emp_dept references dept (deptno),
    mgr number(4),
    foreign key(mgr) references emp1(empno)
);

         