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: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 23 Feb 2006 09:19:41 -0800
Message-ID: <1140715164.900194@jetspin.drizzle.com>


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.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Feb 23 2006 - 11:19:41 CST

Original text of this message

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