Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Function Procedure Packages

 

Using Named Notation

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>