Collections:
Define a Procedure inside another Procedure in Oracle
How To Define a Procedure inside Another Procedure in Oracle?
✍: FYIcenter.com
Define a procedure inside another procedure is supported by PL/SQL. The following tutorial script shows you an example:
SQL> CREATE OR REPLACE PROCEDURE HR.DBA_WEEK AS 2 PROCEDURE DBA_TASK (day VARCHAR2) AS 3 BEGIN 4 IF day = 'MONDAY' THEN 5 DBMS_OUTPUT.PUT_LINE('Checking log files.'); 6 ELSIF day = 'FRIDAY' THEN 7 DBMS_OUTPUT.PUT_LINE('Rebuild indexes.'); 8 ELSE 9 DBMS_OUTPUT.PUT_LINE('Reading some papers.'); 10 END IF; 11 END; 12 BEGIN 13 DBA_TASK('MONDAY'); 14 DBA_TASK('TUESDAY'); 15 END; 16 / SQL> EXECUTE DBA_WEEK; Checking log files. Reading some papers.
Remember that procedures used inside a procedure must be defined in the declaration block.
⇒ What Do You Think about PL/SQL in Oracle
⇐ Example of Passing Parameters to Procedures in Oracle
2019-02-18, 1652🔥, 0💬
Popular Posts:
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
How To Present a Past Time in Hours, Minutes and Seconds in MySQL? If you want show an article was p...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
Where to find reference information and tutorials on MySQL database functions? I want to know how to...