General MySQL Oracle SQL Server

Open a Cursor Variable in Oracle

Q

How To Open a Cursor Variable in Oracle?

✍: FYIcenter.com

A

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

⇑ Working with Cursors in Oracle PL/SQL

⇑⇑ Oracle Database Tutorials

2018-07-18, 3405🔥, 0💬

General MySQL Oracle SQL Server