1create table EMPLOYEES (
2 empno number,
3 name varchar2(50) not null,
4 job varchar2(50),
5 manager number,
6 hiredate date,
7 salary number(7,2),
8 commission number(7,2),
9 deptno number,
10 constraint pk_employees primary key (empno),
11 constraint fk_employees_deptno foreign key (deptno)
12 references DEPARTMENTS (deptno)
13);