What Is a Cursor Variable in Oracle

Q

What Is a Cursor Variable in Oracle?

✍: FYIcenter.com

A

A cursor variable is a variable of a specific REF CURSOR data type, which is a pointer to a data structure resource connects to query statement result, similar to the CURSOR data type.. The advantage of using cursor variables is that cursor variables can be used as variables to pass between procedures and functions.

 

Define a Cursor Variable in Oracle

Pass a Parameter to a Cursor in Oracle

Working with Cursors in Oracle PL/SQL

⇑⇑ Oracle Database Tutorials

2018-04-07, 1594🔥, 0💬