oracle存储过程练习题

--建表：
create table emp_test(
worker_no  varchar2(50),---员工工号
income  int,---员工工资
department varchar2(50)--部门
);

---插入数据
insert into emp_test
select '200010',5000,'10号部门'  from dual union all
select '200011',5000,'20号部门'  from dual union all
select '200012',5000,'30号部门'  from dual union all
select '200013',5000,'40号部门'  from dual union all
select '200014',5000,'20号部门'  from dual union all
select '200015',5000,'40号部门'  from dual

1、创建一个存储过程，以员工号为参数，输出该员工的工资

create or replace procedure income(id  in emp_test.worker_no%type,