Cursor Type

Which cursor type do you use to retrieve multiple recordsets?

Questions by deepakchoubey

Showing Answers 1 - 9 of 9 Answers

priyanka066

  • Dec 17th, 2009
 

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.

  Was this answer useful?  Yes

gakorde

  • Oct 5th, 2010
 

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

Nonscrollable: Can be traversed only in one direction and cannot skip rows

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions