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 10:24:35 -0800
Message-ID: <1140719075.190331.138010@j33g2000cwa.googlegroups.com>


DA Morgan ha escrito:

> PHernandez wrote:
> > 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

>

> They do ... there is almost no excuse for anyone with 9i or above to
> ever use a cursor loop.

>
> Go to Morgan's Library at www.psoug.org and look up Bulk Binding.

hmmm, I thought I knew bulk binding- seems I have to look in to it again :-[

Thanks for pointing it out- twice

--ph Received on Thu Feb 23 2006 - 12:24:35 CST

Original text of this message

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