SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE DEPARTMENT ( id number not null, name varchar2(100) not null ); create unique index department_pk on department(id); alter table department add constraint department_pk primary key(id); CREATE TABLE EMPLOYEE ( id number not null, department_id number, chief_id number, name varchar2(100) not null, salary number ); create unique index employee_pk on employee(id); create index employee_fk1 on EMPLOYEE(department_id); create index employee_fk2 on EMPLOYEE(chief_id); alter table EMPLOYEE add constraint EMPLOYEE_pk primary key(id); alter table EMPLOYEE add constraint fk1_EMPLOYEE foreign key (department_id) references department(id); alter table EMPLOYEE add constraint fk2_EMPLOYEE foreign key (chief_id) references chief_id; select * from DEPARTMENT; select * from EMPLOYEE;