replace or replace procedure test(a out varchar2) is i int; j int; begin i:=10; j:=20; a:=i||','||j; end;
create or replace procedure test(rst out varchar2) is begin declare i int; j int; s varchar2(100); begin i:=10; j:=20; s:='s'; rst:=i||','||j||','||s; end; end;
declare
i int;
j int;
s varchar2(100);
begin
i:=10;
j:=20;
s:='s';
dbms_output.put_line(i||','||j||','||s);
end;--Result
10,20,s
dbms_output.put_line(i||','||j||','||s);
谢谢了
is
i int;
j int;
begin
i:=10;
j:=20;
a:=i||','||j;
end;
is
begin
declare
i int;
j int;
s varchar2(100);
begin
i:=10;
j:=20;
s:='s';
rst:=i||','||j||','||s;
end;
end;