Interested to Buy Any Domain ? << Click Here >> for more details...
What is the use of cursor ? how cursor allocate context area for executing the sql statement?
- 4 Answers
- 16192 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / sowmya
Hi
cursors allow row -by-row processing of the resultsets
Types of cursors are: static,dynamic,
forward-only,keyset-driven,
disadvantages of cursors are : each time you fetch a row
from the cursor,it results in a network roundtrip,where are
as normal select query makes only one round trip
cursors are costly as they need temparory storage.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is the advantage of nosql?
What is trigger in sql and its types?
what are null values? : Sql dba
What is a boolean in sql?
tell me about various levels of constraint. : Sql dba
How to run sql*plus commands in sql developer?
What is dialect in sql?
Does sql require a server?
Who developed sql?
what is a relationship and what are they? : Sql dba
What is example of database?
What is sql query limit?
What is union, minus and interact commands?
Can we join more than 2 tables in sql?
what are all types of user defined functions? : Sql dba
