0 votes
in Oracle by

What is a cursor variable?

1 Answer

0 votes
by
A cursor variable is a cursor that contains a pointer to a query result set. The result set is determined by execution of the OPEN FOR statement using the cursor variable.

A cursor variable, unlike a static cursor, is not associated with a particular query. The same cursor variable can be opened a number of times with separate OPEN FOR statements containing different queries. A new result set is created each time and made available through the cursor variable.

Related questions

0 votes
0 votes
asked Jul 29, 2020 in Oracle by Hodge
0 votes
asked May 11, 2020 in Oracle by JackTerrance
...