Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Learning Cursors
Every SQL statement is a cursor. I take you are really talking about
explicit cursors and cursor for loops.
A cursor may be necessary when you need to process each row in a result set individually in your logic. Generally speaking the logic needs to be complex and not easily solved within a single query. Otherwise you should code the single query. The presence of bad data or error conditions that need to be dealt with on an individual basis while the remander of the data is processes might be a reason to use a cursor.
HTH -- Mark D Powell -- Received on Wed Feb 22 2006 - 19:47:11 CST