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 - 5 of 5 Answers

Rajasekar

  • 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

narenra

  • 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

naresh

  • 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

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