create or replace procedure addsal(pno in emp.empno%type) as
prec emp%rowtype;
begin
select * into prec from emp t where t.empno = pno;
update emp t set t.sal = t.sal + 100 where t.empno = pno;
;
dbms_output.put_line('漲工資前是:' || prec.sal || '漲工資后是:' ||
(prec.sal + 100));
end;
uj5u.com熱心網友回復:
沒有錯誤你發啥啊,難道讓別人來猜?begin
addsal(7369);
end;
轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/34701.html
標籤:基礎和管理
上一篇:PL/SQL怎么實作行列轉制
下一篇:Oracle不顯示序號1
