--查询指定员工的姓名、月薪和职位
create or replace procedure queryEmp(eno in number,
pename out varchar2,
psal out number,
pjob out varchar2)
as
begin
--得到员工的信息
select ename,sal,empjob into pename,psal,pjob from emp where empno = eno;
end;
/
没看出错来
create or replace procedure Raiseaslary(eno in number)
as
psal emp.sal%type;
begin
select sal into psal from emp where empno =eno;
update emp set sal = sal+100 where empno=eno;
dbms.output.put_line('涨前：'||psal||'涨后：'||(psal+100));
end;
/
我哪里错了
