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;