存储过程

 insert into pltest1 values('aaa');
 insert into pltest1 values('bbb');
 
begin
 insert into pltest1 values('aaa');
 insert into pltest1 values('bbb');

end;

set serveroutput on
begin
  dbms_output.put_line('hehehhe');
end;

 set serveroutput on
 begin
   dbms_output.put_line('hehehhe');
 end;
 /
create procedure abc
is
begin
  dbms_output.put_line('hehehhe');
end;

exec abc;

create procedure change_salary(name in varchar2,
salary in number)
is
begin
  update emp set sal=salary
  where ename=name;
  commit;
end;

 declare
 ji number;
 begin
   mianji(3,3,ji);
  dbms_output.put_line(ji);
 end;

create procedure mianjizhouchang (chang in number,kuan in number,
mianji out number,zhouchang out number)
is
begin
  mianji:=chang*kuan;
  zhouchang:=2*(chang+kuan);
end;

declare
mianji number;zhouchang number;
begin
  mianjizhouchang(6,6,mianji,zhouchang);
  dbms_output.put_line(mianji);
  dbms_output.put_line(zhouchang);
end;