![]() |
|||
|
![]() |
![]() |
|
FULL A - Z Oracle Function Library (formerly named "Morgan's Library")
![]() Term: OUT
Definition:
Example Syntax: PARAMETER [IN | OUT | IN OUT] [DATA TYPE] [DEFAULT], Example Usage: The procedure P_GET_SAL fetches the salary of an employee from EMPLOYEE table for the given employee id and returns it to the calling environment. CREATE OR REPLACE PROCEDURE P_GET_SAL (P_EMPID NUMBER, P_SAL OUT NUMBER) Functionally, the code above may be used as in this example: SQL> VAR G_SAL NUMBER; Related Links:
Related Code Snippets:
![]() ![]() ![]() ![]() |
![]() |
Home | Search | Code Library | Sponsors | Privacy | Terms of Use | Contact Us | © 2003 - 2025 psoug.org |