* In short, the cursor selects multiple rows from the database and these selected rows are individually processed within a program.
* There are two types of cursors:
Implicit Cursor :
* Oracle automatically creates a cursor while running any of the commands - SELECT INTO, INSERT, DELETE or UPDATE
implicitly.
* The execution cycle of these cursors is internally handled by Oracle and returns the information and status of the cursor by making use of the cursor attributes- ROWCOUNT, ISOPEN, FOUND, NOTFOUND.
Explicit Cursor :
* This cursor is a SELECT
statement that was declared explicitly in the declaration block.
* The programmer has to control the execution cycle of these cursors starting from OPEN to FETCH and close.
* The execution cycle while executing the SQL statement is defined by Oracle along with associating a cursor with it.