Collections:
Define a Sub Function in Oracle
How To Define a Sub Function in Oracle?
✍: FYIcenter.com
A sub function is a function defined and used inside another procedure or function. You need to define a sub function in the declaration part of the enclosing procedure or function. Sub function definition starts with the FUNCTION key word. Here is a sample script showing you how to define and use a sub function:
SQL> CREATE OR REPLACE PROCEDURE SUM_TEST AS 2 FUNCTION MY_SUM(X NUMBER, Y NUMBER) 3 RETURN NUMBER AS 4 BEGIN 5 RETURN X + Y; 6 END; 7 BEGIN 8 DBMS_OUTPUT.PUT_LINE('3 + 5 = ' || 9 TO_CHAR(MY_SUM(3,5))); 10 DBMS_OUTPUT.PUT_LINE('5 + 3 = ' || 11 TO_CHAR(MY_SUM(5,3))); 12 END; 13 / SQL> EXECUTE SUM_TEST; 3 + 5 = 8 5 + 3 = 8
⇒ Call Procedure or Function Recursively in Oracle
⇐ Call a Sub Procedure in Oracle
2018-03-18, 1772🔥, 0💬
Popular Posts:
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...