Function Definition « Stored Procedure Function « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Stored Procedure Function
  3. Function Definition
1.Define and call a function
2.Define and use function in select clause
3.A stored function.
4.Use user-defined function in if statement
5.Recursive function
6.function with no return type
7.Recursive function Factorial
8.A local function
9.Recursive function 2




10.demonstrates the behavior of the DETERMINISTIC keyword.
11.Function to convert celsius to fahrenheit
12.Function to convert fahrenheit to celsius
13.A function is executed like any other SQL built-in function:
14.Count Employee from a function and return value back
15.How stored functions can be called from SQL
16.Raise exception from inner function