SQL>
SQL> create or replace procedure p_print(i_str1 VARCHAR2 :='hello',
2 i_str2 VARCHAR2 :='world',
3 i_end VARCHAR2 :='!' )
4 is
5 begin
6 DBMS_OUTPUT.put_line(i_str1||','||i_str2||i_end);
7 end;
8 /
Procedure created.
SQL>
SQL> declare
2 begin
3 p_print(i_str2=>'people'); -- just the second
4 p_print(i_end=>'...'); -- just the third
5 p_print(i_end=>'...',i_str2=>'people'); -- mix
6 end;
7 /
hello,people!
hello,world...
hello,people...
PL/SQL procedure successfully completed.
SQL>