Collections:
Example of Passing Parameters to Procedures in Oracle
How To Pass Parameters to Procedures in Oracle?
✍: FYIcenter.com
Store procedures or functions can take parameters. You need to define parameters while defining the procedure, and providing values to parameters while calling the procedure. The script below shows you how to do this:
SQL> CREATE OR REPLACE PROCEDURE DBA_TASK (day VARCHAR2) AS 2 BEGIN 3 IF day = 'MONDAY' THEN 4 DBMS_OUTPUT.PUT_LINE('Checking log files.'); 5 ELSIF day = 'FRIDAY' THEN 6 DBMS_OUTPUT.PUT_LINE('Rebuild indexes.'); 7 ELSE 8 DBMS_OUTPUT.PUT_LINE('Reading some papers.'); 9 END IF; 10 END; 11 / SQL> EXECUTE DBA_TASK('MONDAY'); Checking log files. SQL> EXECUTE DBA_TASK('SUNDAY'); Reading some papers.
As you can see, procedures with parameters can make procedures more flexible.
⇒ Define a Procedure inside another Procedure in Oracle
⇐ Manage Transaction Isolation Levels in Oracle
2019-03-08, 1673🔥, 0💬
Popular Posts:
Collections: Interview Questions MySQL Tutorials MySQL Functions Oracle Tutorials SQL Server Tutoria...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...