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
- 16444 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 right join in sql?
What is sql scripting?
What are the datatypes available in pl/sql ?
Why are indexes and views important to an organization?
what are the type of locks ? : Sql dba
What are all the different normalization?
What is output spooling in sql*plus?
What are crud methods?
Where not exists in sql?
explain the difference between myisam static and myisam dynamic. : Sql dba
Do prepared statements prevent sql injection?
Can a table contain multiple primary key’s?
How can I delete duplicate rows?
how does a local variable is defined using t-sql? : Transact sql
Is null operator in sql?
