Collections:
Open a Cursor Variable in Oracle
How To Open a Cursor Variable in Oracle?
✍: FYIcenter.com
A cursor variable must be opened with a specific query statement before you can fetch data fields from its data rows. To open a cursor variable, you can use the OPEN ... FOR statement as shown in the following tutorial exercise:
CREATE OR REPLACE PROCEDURE FYI_CENTER AS TYPE emp_ref IS REF CURSOR RETURN employees%ROWTYPE; TYPE any_ref IS REF CURSOR; emp_cur emp_ref; any_cur any_ref; sys_cur SYS_REFCURSOR; BEGIN OPEN emp_cur FOR SELECT * FROM employees; OPEN any_cur FOR SELECT * FROM employees; OPEN sys_cur FOR SELECT * FROM employees; CLOSE sys_cur; CLOSE any_cur; CLOSE emp_cur; END; /
⇒ Loop through a Cursor Variable in Oracle
⇐ Define a Cursor Variable in Oracle
2018-07-18, 1936🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...