Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Learning Cursors
"PHernandez" <phph109_at_yahoo.es> wrote in message
news:1140705075.095896.244040_at_p10g2000cwp.googlegroups.com...
> 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
>
Yes, how else would you get the information?
Jim
Received on Thu Feb 23 2006 - 08:54:32 CST