Using Named Notation : Parameters « Function Procedure Packages « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Function Procedure Packages
3. Parameters

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>
SQL>