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, 3528🔥, 0💬
Popular Posts:
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...