What is cursor and where do you use them?

Question Posted / mihir

2 Answers
8544 Views
eBay, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

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 concept of dbms?

0 Answers

What are the objectives of rdbms?

0 Answers

I have 2 tables with 1 million rows each. I have updated 1 row in first and 1 million update on second table. Now I commit both the updates. Which one will commit fast and Why?

0 Answers

What is tuple in rdbms?

0 Answers

Is facebook a database?

0 Answers

Why not phenix, the zelinka/otwinoski libraries, etc?

0 Answers

What is dba in dbms?

0 Answers

Can A CONTROL BLOCK can sometimes refer to a Basetable ?

1 Answers

What is big data in database?