Mega Code Archive
Functions
<![CDATA[
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.
]]>