| 27. 1. 1. Functions |
|
|
A function is similar to a procedure except that a function must return a value. |
You create a function using the CREATE FUNCTION statement. |
The simplified syntax for the CREATE FUNCTION statement is as follows: |
|
CREATE [OR REPLACE] FUNCTION function_name
[(parameter_name [IN | OUT | IN OUT] type [, ...])]
RETURN type
{IS | AS}
BEGIN
function_body
END function_name;
|
|
where |
- OR REPLACE specifies the function that is to replace an existing function if present.
- type specifies the PL/SQL type of the parameter.
- The body of a function must return a value of the PL/SQL type specified in the RETURN clause.
|