The create or replace procedure addsal (pno in emp. The empno % type) as
Prec emp % rowtype;
The begin
Select * into prec from emp where t t.e mpno=pno;
Update the emp t set t.s al=t.s al + 100 where t.e mpno=pno;
;
Dbms_output. Put_line (' wages before is: '| | prec. Sal | |' after a wage increase is: '| |
(prec. Sal + 100));
end;

CodePudding user response:

No errors you hair what ah, don't let others to guess?

The begin
Addsal (7369);
end;