PL/SQL Functions

PL/SQL Functions

What is a Function in PL/SQL?

A function is a named PL/SQL Block which is similar to a procedure. The major difference between a procedure and a function is, a function must always return a value, but a procedure may or may not return a value.

The General Syntax to create a function is:

CREATE [OR REPLACE] FUNCTION function_name [parameters]

RETURN return_datatype; 

IS 

Declaration_section 

BEGIN 

Execution_section

Return return_variable; 

EXCEPTION 

exception section 

Return return_variable; 

END;