/*
创建一个存储过程，返回指定员工的姓名和薪水
*/
create or replace PROCEDURE queryEmp1(eno in number,empname out VARCHAR2,empsal out NUMBER)
as
begin
select ename,sal into empname,empsal from emp where empno=eno;
end;
/
创建一个存储过程，返回指定员工的姓名和薪水
*/
create or replace PROCEDURE queryEmp1(eno in number,empname out VARCHAR2,empsal out NUMBER)
as
begin
select ename,sal into empname,empsal from emp where empno=eno;
end;
/
