What is the use of cursors in PL/SQL ? What is REF Cursor ?

The cursor are used to handle multiple row query in PL/SQL. Oracle uses implicit cursors to handle all itís queries. Oracle uses unnamed memory spaces to store data used in implicit cursors, with REF cursors you can define a cursor variable which will point to that memory space and can be used like pointers in our 3GLs.   

Showing Answers 1 - 6 of 6 Answers


  • Apr 2nd, 2006

If you have not used REF cursor, then when you need to open cursors multiple time, it will throw an error. Because in a procedure there is a limitation availe for maximum number of cursors to be open at any point of time.

  Was this answer useful?  Yes


  • Aug 9th, 2011

Generally we use cursor to get multiple Result. and Specify a particular name of storage area . by cursor we know that active set. where is position of cursor.

  Was this answer useful?  Yes


  • Dec 11th, 2011

Cursor is a private SQL memeory area which retrieving multiple data or record by record through single variable and selected variable.

  Was this answer useful?  Yes

Vijaya bhaskar

  • Jul 27th, 2012

you can fetch the more rows and insert into another table easily

  Was this answer useful?  Yes

Kuna Sahu

  • May 12th, 2016

Cursor is a SQL private memory area which is used to retrieve multiple record and process record by record process.

  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.

Answer Question

Click here to Login / Register your free account

Send   Reset


Related Answered Questions


Related Open Questions