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





Pass number value to function

    


SQL> CREATE OR REPLACE FUNCTION celsius_to_fahrenheit (degree NUMBER) RETURN NUM
BER IS
  2      buffer NUMBER;
  3  BEGIN
  4     buffer := (degree * 9/5) + 32;
  5     RETURN buffer;
  6  END celsius_to_fahrenheit;
  7  /

Function created.

SQL>
SQL>

   
    
    
    
  










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.Mixed Name and Position Notation Calls