Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Learning Cursors
Mark D Powell ha escrito:
> 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.
I have a follow up question on this, if I have a query that returns > 1 row and I'd want to display the result in a gui of some sort, e.g. a web-page- I'm pretty much stuck with a cursor, right? Or are there other ways to do it?
--ph
Oracle 10g Received on Thu Feb 23 2006 - 08:31:15 CST