Mixed Name and Position Notation Calls : Function Parameters « Stored Procedure Function « Oracle PL / SQL






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

Mixed Name and Position Notation Calls

    


SQL> CREATE OR REPLACE FUNCTION add_three_numbers( a NUMBER := 0, b NUMBER := 0, c NUMBER := 0 ) RETURN NUMBER IS
  2  BEGIN
  3    RETURN a + b + c;
  4  END;
  5  /

Function created.








Related examples in the same category

1.Pass value to function parameter
2.Boolean value function parameter
3.The FullName Function
4.A stored function with no parameters.
5.Use Column type as the function parameter type
6.Varray type parameter
7.Clob type parameter
8.Positional Notation
9.Get circle area
10.Named Notation
11.Pass number value to function