Dynamic Cursors:

As the name suggests Dynamic Cursors, are a set of cursors where the records from the tables are selected at run time rather than at compile time. These are dealt in the latter part of this chapter.

Each cursor has four attributes

%ROWCOUNT         Returns the number of rows processed through a SQL statement.

%FOUND                   Contain TRUE if at least one row is processed

%NOTFOUND          Contain TRUE if no rows are processed.

%ISOPEN                  Contain TRUE if a cursor is open or

FALSE if cursor has not been opened or has been closed. This attributes are used only in connection with explicit cursors.

%ROWCOUNT

The %ROWCOUNT attribute is used to return the number of records fetched. This is in agreement with the number of FETCHes done.

%FOUND

This attribute holds TRUE if the FETCH statement fetches any records. The attribute will contain FALSE if there are no records to be fetched.

%NOTFOUND

It is the opposite of %FOUND logically. If records are fetched, the %NOTFOUND is FALSE and TRUE if there are no more records to be processed. By using this we can terminate from the loop.

%ISOPEN

This attribute checks for the status of if the status of the cursor is open or not. If the cursor is opened, it contains TRUE and FALSE if the cursor is not opened.

The tabular structure described this better.