Collections:
Pass a Parameter to a Cursor in Oracle
How To Pass a Parameter to a Cursor in Oracle?
✍: FYIcenter.com
When you define a cursor, you can set a formal parameter in the cursor. The formal parameter will be replaced by an actual parameter in the OPEN cursor statement. Here is a good example of a cursor with two parameters:
CREATE OR REPLACE PROCEDURE FYI_CENTER AS CURSOR emp_cur(low NUMBER, high NUMBER) IS SELECT * FROM employees WHERE salary >= low AND salary <= high; BEGIN FOR row IN emp_cur(12000,15000) LOOP DBMS_OUTPUT.PUT_LINE(row.first_name || ' ' || row.last_name || ': ' || row.salary); END LOOP; END; / Nancy Greenberg: 12000 John Russell: 14000 Karen Partners: 13500 Alberto Errazuriz: 12000 Michael Hartstein: 13000 Shelley Higgins: 12000
⇒ What Is a Cursor Variable in Oracle
⇐ Open Multiple Cursors at the Same Time in Oracle
2018-07-18, 1392🔥, 0💬
Popular Posts:
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...