|
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('Hi',i_end=>'...'); -- mixed
4 p_print(i_str1=>'Hi',i_end=>'...'); -- pure named
5 end;
6 /
Hi,world...
Hi,world...
PL/SQL procedure successfully completed.
SQL>
SQL>
|