create or replace procedure pro_s(n1 in out number, n2 in out number)
as
v_temp number;
begin
v_temp:=n1;
n1:=n2;
n2:=v_temp;
end;
uj5u.com熱心網友回復：
它呼叫的話需要怎么打？救救，小白吧！！！uj5u.com熱心網友回復：
create or replace procedure pro_s(n1 in out number, n2 in out number)
as
v_temp number;
begin
v_temp:=n1;
n1:=n2;
n2:=v_temp;
end;
declare
aaa number:=1;
bbb number:=2;
begin
pro_s(aaa, bbb);
dbms_output.put_line(aaa);
dbms_output.put_line(bbb);
end;
drop procedure pro_s;
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/18067.html
標籤：基礎和管理