例子:SQL> create or replace procedure p_test (i in int default 2)
2 as
3 begin
4 sys.dbms_output.put_line(i);
5 end;
6 /Procedure created.SQL> set serverout on
SQL> exec p_test;
2PL/SQL procedure successfully completed.SQL> exec p_test(4)
4PL/SQL procedure successfully completed.
2 as
3 begin
4 sys.dbms_output.put_line(i);
5 end;
6 /Procedure created.SQL> set serverout on
SQL> exec p_test;
2PL/SQL procedure successfully completed.SQL> exec p_test(4)
4PL/SQL procedure successfully completed.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货