What Is a Function
Q
What Is a Function? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions
✍: FYIcenter.com
A
A function is a named program unit. It consists of three parts:
- Declaration Part - Defining the function name, calling parameters, return value type, local variables and local procedures. Declaration part is required.
- Execution Part - Defining execution logic with executable statements. Execution part is required.
- Exception Part - Defining error handling logics. Exception part is optional.
Here how a complete procedure should look like:
FUNCTION name (parameter_1, parameter_2) RETURN type AS -- Declaration statements BEGIN -- Executable statements RETURN value; EXCEPTION -- Error handling statements END;
2007-04-26, 4843👍, 0💬
Related Topics:
