参数的默认值SQLCREATEORREPLACEPROCEDUREHelloWorld3(2p_user_nameVARCHAR2,3p_val1VARCHAR2DEFAULT\'GoodMoning,\',4p_val2VARCHAR2DEFAULT\'NicetoMeetyou\'5)AS6BEGIN7dbms_output.put_line(\'Hello\'||p_user_name||p_val1||p_val2||\'!\');8ENDHelloWorld3;9/Procedurecreated.指定参数名称调用此部分使用“参数默认值”那一小节的存储过程。用于说明当最后2个参数是有默认的时候,如何跳过中间那个。SQLBEGIN2HelloWorld3(\'Edward\');3HelloWorld3(\'Edward\',p_val1=\'GoodNight,\');4HelloWorld3(\'Edward\',p_val1=\'GoodNight,\',p_val2=\'Bye\');5HelloWorld3(\'Edward\',p_val2=\'HeiHei\');6END;7/HelloEdwardGoodMoning,NicetoMeetyou!HelloEdwardGoodNight,NicetoMeetyou!HelloEdwardGoodNight,Bye!HelloEdwardGoodMoning,HeiHei!PL/SQLproceduresuccessfullycompleted.参考资料:http://hi.baidu.com/wangzhiqing999/blog/item/0991d3124070854420a4e9b4.html
|