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
- 16385 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
How does rowid help in running a query faster?
How do you write an index?
define sql insert statement ? : Sql dba
What does the base_object_type column shows in the user.triggers data dictionary view?
Why left join is used in sql?
How do I truncate a sql log file?
Is it possible to read/write files to-and-from PL/SQL?
Does normalization improve performance?
What is date functions?
what is union? : Sql dba
Who is the owner of mysql database?
How do sql triggers work?
Explain about various levels of constraint.
What is package in pl sql with an examples?
What is the difference between between and in condition operators?
