What is the use of cursor ? how cursor allocate context area for executing the sql statement?
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
Write a sql query to convert all character to uppercase after hypen.
Explain the the update statement in sql?
How to connect a sql*plus session to an oracle server?
What is the difference between truncate and drop statements?
what are enums used for in mysql? : Sql dba
What are tables and fields in the database?
What is a stored procedure in sql with example?
What are the different types of dbmss?
What is the difference between delete and truncate statement in sql?
Is sql harder than python?
What is the difference between the conventional and direct path loads? : aql loader
how can we find the number of rows in a table using mysql? : Sql dba
What does fetching a cursor do?
Can we use two order by clause in query?
Which is faster count (*) or count 1?