Cursor attributes (PL/SQL)

 Each cursor has a set of attributes that enables an application program to test the state of the cursor.

These attributes are 

%ISOPEN:

This attribute is used to determine whether a cursor is in the open state. When a cursor is passed as a parameter to a function or procedure, it is useful to know (before attempting to open the cursor) whether the cursor is already open.

 %FOUND: 

This attribute is used to determine whether a cursor contains rows after the execution of a FETCH statement. If FETCH statement execution was successful, the %FOUND attribute has a value of true. If FETCH statement execution was not successful, the %FOUND attribute has a value of false. 

%NOTFOUND:

This attribute is the logical opposite of the %FOUND attribute.

%ROWCOUNT:

This attribute is used to determine the number of rows that have been fetched since a cursor was opened.