If you are after the n'th degree performance then the: for x in (select ... )
will be minisculely faster (simply because its slightly less code and plsql is interpreted). And unless I have a particular need for the cursor %attributes, or the cursor needs to be passed around I prefer the sql directly in the for-loop. I don't have to hunt up through the procedure/package to find the cursor definition, and (subjectively) I find it easier to read. hth connor --- Tim Gorman <[EMAIL PROTECTED]> wrote: > Both use cursors, but a FOR loop is more concise > coding. Technically, they > are exactly equivalent; the differences are just > stylistic... > > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" > <[EMAIL PROTECTED]> > Sent: Monday, February 24, 2003 3:08 AM > > > > I would suggest that the cursor is the best way to > go. > > -----Original Message----- > > Sent: 24 February 2003 08:39 > > To: Multiple recipients of list ORACLE-L > > > > > > > > Hello, > > > > I was just asked by one of our developers which is > beter to use:- > > a cursor or a for loop? > > I must admit I am not sure.... > > > > Anyway the specific piece of code in discussion is > similar to the > > following.... > > > > FOR X IN (SELECT X FROM TABLE_NAME > > WHERE COL1 = 'Something')) > > LOOP > > Do a whole lot of stuff in > database here...... > > LOOP END; > > > > I would guess that the cursor would follow similar > execution criteria but > > using > > the cursor syntax. > > > > Any ideas? > > > > TIA > > regards > > Denham Eva > > Oracle DBA > > The real problem is not whether machines think but > whether men do. > > - B. F. Skinner > > > > > > _____ > > > > DISCLAIMER > > > > This message is for the named person's use only. > It may contain > > confidential, proprietary or legally privileged > information. No > > confidentiality or privilege is waived or lost by > any mistransmission. If > > you receive this message in error, please > immediately delete it and all > > copies of it from your system, destroy any hard > copies of it and notify > the > > sender. You must not, directly or indirectly, use, > disclose, distribute, > > print, or copy any part of this message if you are > not the intended > > recipient. TFMC, its holding company, and any of > its subsidiaries each > > reserve the right to monitor and manage all e-mail > communications through > > its networks. > > > > Any views expressed in this message are those of > the individual sender, > > except where the message states otherwise and the > sender is authorized to > > state them to be views of any such entity. > > > > _____ > > > > > > _____ > > > > This e-mail message has been scanned for Viruses > and Content and cleared > by > > MailMarshal - For more information please visit > > <http://www.marshalsoftware.com> > www.marshalsoftware.com > > _____ > > > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > > -- > > Author: Thomas, Kevin > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 > http://www.fatcity.com > > San Diego, California -- Mailing list and > web hosting services > > > --------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > ORACLE-L > > (or the name of mailing list you want to be > removed from). You may > > also send the HELP command for other information > (like subscribing). > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Tim Gorman > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 > http://www.fatcity.com > San Diego, California -- Mailing list and web > hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > ===== Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).