Pass value to function parameter : Function Parameters « Stored Procedure Function « Oracle PL / SQL






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

Pass value to function parameter

   

SQL> -- The stored function squareme.
SQL> CREATE OR REPLACE FUNCTION squareme(thenum number)
  2       RETURN NUMBER IS
  3  BEGIN
  4       RETURN thenum * thenum;
  5  END squareme;
  6  /

Function created.

SQL>
SQL>
SQL>
SQL> -- Passing parameters to squareme.
SQL> BEGIN
  2       DBMS_OUTPUT.PUT_LINE('9 squared is ' || squareme(9) );
  3  END;
  4
  5  /
9 squared is 81

PL/SQL procedure successfully completed.








Related examples in the same category

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