Un ref cursor est en fait une variable curseur. Il n'y pas de différence fondamentale entre un curseur et une variable curseur!
A cursor is a pointer to a private SQL area that stores information about processing a specific SQL statement or PL/SQL SELECT INTO statement.Bref, je vous invite à nous démontrer le "gain de performance assez énorme ..."A cursor variable is like an explicit cursor, except that:
■ It is not limited to one query.
You can open a cursor variable for a query, process the result set, and then use the
cursor variable for another query.
■ It can be a subprogram parameter.
You can use cursor variables to pass query result sets between subprograms.
■ It can be a host variable.
You can use cursor variables to pass query result sets between PL/SQL stored
subprograms and their clients.
Partager