Oracle_存储过程

最简单的存储过程：

create or replace procedure fuck  
is
begin
update emp set sal = (select max(sal) from emp) where empno = (select empno from emp where sal = 800);
commit;
end;