What is cursor and where do you use them?

Answers were Sorted based on User's Feedback



What is cursor and where do you use them?..

Answer / rajesh

Cursor is an named private area called active set which is
used to process the multiple rows returned by the query....
cursors are mainly used in procedure/package/function when
the select qurey in procedure/package/function returns
more than one value....

if their is any issue mail me @
rajesh_natesh@yahoo.com,rajesh.natesh@cognizant.com

Is This Answer Correct ?    3 Yes 1 No

What is cursor and where do you use them?..

Answer / guest

cursor is temperory block of memory which holds the data as
temperory in buffer

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More Database Management Interview Questions

What is a database management system and give examples?

0 Answers  


Define database model.

0 Answers  


Explain, why is rdbms better than dbms?

0 Answers  


Explain the terms database and dbms. Also, mention the different types of dbms.

0 Answers  


How to tell firebird to only accept conections from xyz host or network?

0 Answers  






Why do we need database management?

0 Answers  


Is mysql a rdbms?

0 Answers  


Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ?

0 Answers  


What is use of dbms?

0 Answers  


What do you understand by data redundancy?

0 Answers  


How to prevent concurrent access to my data?

0 Answers   HCL,


how to pass values from one table to another by using Bulk collect?

3 Answers   Oracle, Wipro,


Categories