What is the use of cursor ? how cursor allocate context area for executing the sql statement?
- 4 Answers
- 15300 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 sqlca in powerbuilder?
how to check myisam tables for errors? : Sql dba
when MSQL8.0 is in market
what is the different between now() and current_date()? : Sql dba
What are the benefits of pl sql?
How to sort the rows in sql.
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
What is a mutating table and a constraining table?
What is cursor in pl sql with examples?
What is benefit of creating memory optimized table?
How to convert comma separated string to array in pl/sql?
What are the two virtual tables available at the time of database trigger execution?
what is the difference between truncate and delete statement? : Transact sql
Explain what is dbms?
What is exception? What are the types of exceptions?
