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.   
  • Interview Candidate
  • 16
  • 22777

Showing Answers 1 - 16 of 16 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

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.

 

Related Answered Questions

 

Related Open Questions