例如下面代码
declare
v_in number:=1;
v_out number:=2;
v_inout number:=3;
begin
dbms_output.putline('before calling modetest;');
dbms_output.putline('v_in='||v_in||
'v_out='||v_out||
'v_inout='||v_inout);
modetest(v_in,v_out,v_inout);
dbms_output.putline('after calling modetest:');
dbms_output.putline('v_in='||v_in||
'v_out='||v_out||
'v_inout='||v_inout);end;
before calling modetest:
v_in=1 v_out=2 v_inout=3
inside modetest:
p_inparameter=1 p_outparameter is null p_inoutparameter=3
at end of modetest
p_inparameter =1 p_outparameter=7 p_inoutparameter=8
after calling modetest:
v_in=1 v_out=7 v_inout=8
帮忙详细解释下这段代码 尤其是执行的那段,看不太懂怎么来的,还有那个v_out=7 v_inout=8。是怎么来的?
declare
v_in number:=1;
v_out number:=2;
v_inout number:=3;
begin
dbms_output.putline('before calling modetest;');
dbms_output.putline('v_in='||v_in||
'v_out='||v_out||
'v_inout='||v_inout);
modetest(v_in,v_out,v_inout);
dbms_output.putline('after calling modetest:');
dbms_output.putline('v_in='||v_in||
'v_out='||v_out||
'v_inout='||v_inout);end;
before calling modetest:
v_in=1 v_out=2 v_inout=3
inside modetest:
p_inparameter=1 p_outparameter is null p_inoutparameter=3
at end of modetest
p_inparameter =1 p_outparameter=7 p_inoutparameter=8
after calling modetest:
v_in=1 v_out=7 v_inout=8
帮忙详细解释下这段代码 尤其是执行的那段,看不太懂怎么来的,还有那个v_out=7 v_inout=8。是怎么来的?
dbms_output.putline('v_in='||v_in||
'v_out='||v_out||
'v_inout='||v_inout); 'v_in=',这个就是显示的 vin=
|| v_in 就是 6后面依此类推