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, 1370🔥, 0💬
Popular Posts:
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...