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 06:31:15 -0800
Message-ID: <1140705075.095896.244040@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 Received on Thu Feb 23 2006 - 08:31:15 CST

Original text of this message

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