Cursor Attributes.

Cursor Attributes:

• There are four attributes available in PL/SQL that can be applied to cursors.
• Cursor attributes are appended to a cursor name in PL/SQL block and then used in expressions.

The attributes are

1. <cursor name>%Found
2. <cursor name>%NotFound
3. <cursor name>%ISOPEN
4. <cursor name>%Rowcount

Active Set:

• The set of rows returned by a multiple-row query is called the Active Set. 

 

 Cursor Active set