Question

What happens to the explicit cursor when commit command is executed?

Answer 1

An Explicit cursor can be found in the declaration section of a PL/SQL block in ORACLE database management systems.

When commit command gets executed, the explicit cursor gets closed.

On executing a commit command the explicit cursor having the query will come out of the session automatically.

The programmer needs to start a fresh loop once again.

Answer 2

Using an explicit cursor involves declaration of the cursor and opening it for a query. After this, the result of the query must be assigned to a PL/SQL variable. After this, the cursor must be closed.

When the COMMIT command is executed, the explicit cursor that processes the DML statement or query associated with it gets closed.