Cursor Type

Explicit cursor

This ans opt for Oracle DB - SYS_REFCURSOR. this is what we called Explicit cursor. In database if you run any sql statement by default system will create a cursor. its called "Implicit cursor". But in PL/SQL, we are using SYS_REFCURSOR to manupulate the multiple records. that is called Explicit cursor.

These is no cursor types in MySQL as it is in Oracle.

Cursors in MySQL have these properties:

Asensitive: The server may or may not make a copy of its result tableRead only: Not updatable