<<Previous Next>>
Oracle - What are the
drawbacks of a cursor? - Feb 07, 2010 at 14:20 PM by
Shuchi Gauri
What are the drawbacks of a
cursor?
Cursors allow row by row processing of
recordset. For every row, a network roundtrip is made unlike in a
Select query where there is just one network roundtrip. Cursors need
more I/O and temp storage resources, thus it is
slower.
Oracle - What
are the drawbacks of a cursor? - June 27, 2009 at 11:00
AM
What are the drawbacks of a
cursor?
- Implicit cursors are less efficient than explicit cursors
- Implicit cursors are more vulnerable to data errors
- Implicit cursors provide less programmatic control
Oracle - What are the advantages of a
cursor? - Feb 23, 2010 at 11:00 PM by Rajmeet
Ghai
Advantages of a cursor
- Cursors can be used to process query results row by row.
- Using cursors, you can get, put, and delete database
records.
- Because the results are processed row by row, data in each row
can be processed in a different way.
Also read
What a SELECT FOR UPDATE cursor represent?, What WHERE CURRENT OF
clause does in a cursor?, Can you pass a parameter to a cursor?,
Explain the functioning of CURSOR FOR LOOP with example., Define
Simple/Explicit , Parametric and Internal/Implicit
cursor.............
Normal cursors fall under the category of static cursors while
REF cursors are dynamic.........
What is an SQL *FORMS?, How do you control the constraints in
forms?, When will ON-VALIDATE-FIELD trigger executed?, What is the
difference between system.current_field and
system.cursor_field?...............
A cursor variable works like pointer in C. It is used to hold
address of an item rather than the item itself. Cursor variables can
be used to hold different values at run time............
The CURSOR FOR UPDATE obtains a lock on a selected number of rows
that have not undergone a COMMIT yet..............
A parameter makes the cursor more reusable, A parameter avoids
scoping problems...............
|
