Which type of cursor variable is used to return the number of rows affected by an insert, update, delete or select statement?

Options
- c%NOTFOUND
- c%ROWCOUNT
- %FOUND
- c%ISOPEN


CORRECT ANSWER : c%ROWCOUNT

Discussion Board
%ROWCOUNT

A cursor attribute that can be appended to the name of a cursor or cursor variable. When a cursor is opened, %ROWCOUNT is zeroed. Before the first fetch, cursor_name%ROWCOUNT returns 0. Thereafter, it returns the number of rows fetched so far. The number is incremented if the latest fetch returned a row.

Prajakta Pandit 02-21-2017 10:55 PM

Write your comments

 
   
 
 

Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement