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, 1388🔥, 0💬
Popular Posts:
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...