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: Mark D Powell <Mark.Powell_at_eds.com>
Date: 22 Feb 2006 17:47:11 -0800
Message-ID: <1140659231.075963.283940@g47g2000cwa.googlegroups.com>


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.

HTH -- Mark D Powell -- Received on Wed Feb 22 2006 - 19:47:11 CST

Original text of this message

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