Default parameter value : Procedure Call « Stored Procedure Function « Oracle PL / SQL

1. Oracle PL / SQL
2. Stored Procedure Function
3. Procedure Call

Default parameter value

   
SQL> set serveroutput on
SQL>
SQL> CREATE OR REPLACE PROCEDURE DefaultTest (
  2    p_ParameterA NUMBER DEFAULT 10,
  3    p_ParameterB VARCHAR2 DEFAULT 'abcdef',
  4    p_ParameterC DATE DEFAULT SYSDATE) AS
  5  BEGIN
  6    DBMS_OUTPUT.PUT_LINE(
  7      'A: ' || p_ParameterA ||
  8      '  B: ' || p_ParameterB ||
  9      '  C: ' || TO_CHAR(p_ParameterC, 'DD-MON-YYYY'));
 10  END DefaultTest;
 11  /

Procedure created.

SQL> show errors
No errors.
SQL>
SQL> BEGIN
  2    DefaultTest(p_ParameterA => 7, p_ParameterC => '30-DEC-95');
  3  END;
  4  /
A: 7  B: abcdef  C: 30-DEC-1995

PL/SQL procedure successfully completed.

SQL>

   
    
  

Related examples in the same category