Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Learning Cursors
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?
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