--查詢指定員工的姓名、月薪和職位
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;
/
我哪里錯了
