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
- 16596 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 can you know that statistics should be updated?
What are the different types of dbmss?
Can we create table in function?
What is cascade in sql?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
What is the difference between having and a where in sql?
What is sequence in sql?
How do I order columns in sql?
What is number function in sql?
Is sql a scripting language?
Is and as keyword in pl sql?
Where is pl sql used?
How do I start sql from command line?
How do I pipe the output of one isql to another?
What is mdb stand for?
