Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Learning Cursors
Jim Kennedy ha escrito:
> "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?
Hey, that's my question!!
To extend it a little. Many times all I do with a cursor is to loop the result and more or less concatenate the rows to a string. e.g: "<person><name>Patrick</name><lname>Green</lname></person><person> .... "
Since it's kind of a trivial task and no doubt very common, I thought that Oracle maybe provide some kind of magic to do it without looping a cursor.
--ph Received on Thu Feb 23 2006 - 10:03:30 CST