Saturday, March 14, 2009

Explicitly Define Parameters

Declare
Procedure pShopList
(i_Verb Varchar2 :='Buy'
,i_Item Varchar2 :=' apples'
,i_Priority Varchar2 :=' now' )
Is
Begin
Dbms_Output.Put_Line(i_Verb
||i_Item
||i_Priority);
End;
Begin
pShopList(i_Item => ' bananas' ); -- 2nd only
pShopList(i_Priority => ' sometime'); -- 3rd only

pShopList(i_Priority => ' sometime'
,i_Item => ' grapes' ); -- Mix
End;
/

No comments:

Post a Comment