ORACLE存储过程习题及答案，题目是网上找的，答案是本人自己写的，仅供参考

 

建表语句：

员工表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(9,10009,'张四',