|
|
FULL A - Z Oracle Function Library (formerly named "Morgan's Library")
Term: FUNCTION
Definition: CREATE [OR REPLACE] FUNCTION [NAME][PARAMETER LIST] RETURN [DATA TYPE] Functions can be stored in the database itself, and are also referred to as stored functions. They permit the reuse of logic, allow for code flexibility, and enable modularity. Unlike procedures, stored functions can also be used in SQL statements, if they obey specific rules to avoid database changes. Example Usage: CREATE OR REPLACE FUNCTION F_AVG_SALARY RETURN NUMBER Related Links:
Related Code Snippets:
|
Home | Search | Code Library | Sponsors | Privacy | Terms of Use | Contact Us | © 2003 - 2024 psoug.org |