GeekInterview.com
Series: Subject: Topic:
Question: 53 of 103

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.   
Asked by: Interview Candidate | Asked on: Aug 15th, 2005
Showing Answers 1 - 5 of 5 Answers
Rajasekar

Answered On : 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.

  
Login to rate this answer.

Cursor is used to process multiple rows in PL/SQL.Ref cursor is dynamic cursor and reusable. Ref cursor allows global declaration of a cursor.

  
Login to rate this answer.
narenra

Answered On : 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.

  
Login to rate this answer.
naresh

Answered On : Dec 11th, 2011

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

  
Login to rate this answer.
Vijaya bhaskar

Answered On : Jul 27th, 2012

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

  
Login to rate this answer.

Give your answer:

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

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.