Difference between implicit and explicit cursor

Question

Accepted Answer

Implicit cursors are automatically created by the Oracle server, while explicit cursors are explicitly declared by the programmer.

Implicit cursors are used for single-row queries, while explicit cursors are used for multi-row queries.
Implicit cursors are automatically opened, fetched, and closed by the Oracle server, while explicit cursors need to be manually opened, fetched, and closed by the programmer.
Implicit cursors are less flexible and have limited control, while explicit cursors provide more control and flexibility to the programmer.
Implicit cursors are suitable for simple queries, while explicit cursors are suitable for complex queries that require more control and processing.
Example of an implicit cursor: SELECT column_name INTO variable_name FROM table_name WHERE condition;
Example of an explicit cursor: DECLARE cursor_name CURSOR FOR SELECT column_name FROM table_name WHERE condition; OPEN cursor_name; FETCH cursor_name INTO variable_name; CLOSE cursor_name;

Accepted Answer

implicit means it is automatically created and explicit means implement the user by name

Accepted Answer

IMPLICIT CURSOR is created and handled by oracle itself when select statement is executedand capable of fetching single row at a time.

EXPLICIT CURSOR is created by the user with a name and handled by user can fetch multiple rows.

Top Cognizant Plsql Developer interview questions & answers