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, 2065🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...