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 updatabl...
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&qu...