建表语句:
员工表emp_test
create table emp_test(
Idnumber(5) notnullprimarykey,
Emp_id number(10) notnull,
Namevarchar2(200) notnull,
Pay number(10,2) default0,
Dept_id varchar2(20) notnull,
entryDate datedefaultsysdate
)
部门信息表dept_test
Create table dept_test(
Id number(5) not null primarykey,
Name varchar2(200) not
null,
Loc varchar2(500)
)
insertinto emp_test values(3,10003,'李三',3500,5,to_date('20170302','yyyy/mm/dd'));
insertinto emp_test values(4,10004,'李四',4500,3,to_date('20170201','yyyy/mm/dd'));
insertinto emp_test values(5,10005,'李五',2500,4,to_date('20170102','yyyy/mm/dd'));
insertinto emp_test values(6,10006,'张一',5500,3,to_date('20170402','yyyy/mm/dd'));
insertinto emp_test values(7,10007,'张二',7500,7,to_date('20170205','yyyy/mm/dd'));
insertinto emp_test values(8,10008,'张三',7500,6,to_date('20170209','yyyy/mm/dd'));
insertinto emp_test values(