create table department( id number primary key, name varchar2(30));
create table employee( id number primary key, name varchar2(30) not null, salary number(6,2), title varchar2(30), manager number, deptid number);
insert into department values(1,'人力资源');
insert into department values(2,'开发中心');
insert into department values(3,'总裁室');
insert into employee values(4,'赵六',9000,'项目经理',null,2);
insert into employee values(3,'王五',7000,'项目组长',4,2);
insert into employee values(1,'张三',6000,'程序员',3,2);
insert into employee values(2,'李四',7000,'HR',4,1);
|