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 the use of PARFILE option in EXP command ?

1 Answers  


What is package in dbms?

0 Answers  


What is the purpose of sql?

0 Answers  


What is a functional dependency in the dbms?

0 Answers  


What are the basic functions of a database?

0 Answers  






Explain about the properties of cursors?

0 Answers  


Enlist the disadvantages of query.

0 Answers  


What is denormalization and why would someone consider doing so?

0 Answers  


What are the functions of a database?

0 Answers  


What are the six database objects?

0 Answers  


If an UNIQUE KEY constraint on DATE column is created, will it accept duplicate values?

2 Answers  


State at least four kinds of indexing?

0 Answers   Amazon, iNautix,


Categories