Explain the cursor types

DYNAMIC: It reflects changes happened on the table while scrolling through the row.

STATIC: It works on snapshot of record set and disconnects from the server. This kind doesn’t reflects changes happened on the table while scrolling through the row.

KEYSET: In this kind, new record is not reflected, but data modification can be seen.

Explain the cursor types.

There are two types of cursors:

1. Implicit Cursor: It is declared automatically when the SQL statement is executed. User is not aware of what is happening and cannot control or process the information available in the implicit cursor.

2. Explicit Cursor: Explicit cursor is defined in PL/SQL block which is to handle the query that fetches more than one row. The developer/programmer needs to declare, open the cursor. Then he/she needs to fetch and process sequentially all the rows and close it.