What are the drawbacks of a cursor?


What are the drawbacks of a cursor?

<<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

Oracle cursors interview questions

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.............

What is the difference between REF Cursor & Normal Cursor in oracle?

Normal cursors fall under the category of static cursors while REF cursors are dynamic.........

Oracle Form

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?...............

What is use of a cursor variable in oracle?

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............

Oracle - use of "for update of"

The CURSOR FOR UPDATE obtains a lock on a selected number of rows that have not undergone a COMMIT yet..............

Oracle - use of parameterized cursor

A parameter makes the cursor more reusable, A parameter avoids scoping problems...............

<<Previous  Next>>

Write your comment - Share Knowledge and Experience


Interview questions
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring