Differentiate between implicit cursor and explicit cursor.

Answer»

IMPLICIT CURSOR	Explicit Cursor
An implicit cursor is used when a query returns a single ROW value.	When a subquery returns more than one row, an explicit cursor is used. These rows are called Active Set.
This is used for all DML operations like DECLARE, OPEN, FETCH, CLOSE.	This is used to process Multirow SELECT Statements.
NO_DATA_FOUND Exception is handled here.	NO_DATA_FOUND cannot be handled here.

Discussion