Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Learning Cursors

Re: Learning Cursors

From: PHernandez <phph109_at_yahoo.es>
Date: 23 Feb 2006 08:03:30 -0800
Message-ID: <1140710610.574095.89360@g47g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US