Fetching Rows From a Cursor Variable v13
After a cursor variable is opened, rows may be retrieved from the result set using the FETCH
statement. See Fetching Rows From a Cursor for details on using the FETCH
statement to retrieve rows from a result set.
In the example below, a FETCH
statement has been added to the previous example so now the result set is returned into two variables and then displayed. Note that the cursor attributes used to determine cursor state of static cursors can also be used with cursor variables. See Cursor Attributes for details on cursor attributes.