Fetching Rows Inserted by Other Queries
While a cursor is open, your application can append rows using non-cursor append statements. If these newly inserted rows are inserted after the current cursor position, the rows are or are not be visible to the cursor, depending on the following criteria:
Updatable cursors
The newly inserted rows are visible to the cursor.
Non-updatable cursors
If the cursor retrieve statement retrieves rows directly from the base table, the newly inserted rows are visible to the cursor. If the retrieve statement manipulates the retrieved rows (for example, includes an sort by clause), the cursor retrieves rows from an intermediate buffer, and cannot detect the newly inserted rows.