Collections:
Pass 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.
⇒ Create a Stored Function in Oracle
⇐ Drop a Stored Procedure in Oracle
2018-11-11, 1688🔥, 0💬
Popular Posts:
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...