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 <Tim_at_SageLogix.com> 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"
> <ORACLE-L_at_fatcity.com>
> 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: KEVIN.THOMAS_at_saic.com
> >
> > 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: ListGuru_at_fatcity.com (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: Tim_at_SageLogix.com
>
> 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: ListGuru_at_fatcity.com (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: connor_mcdonald_at_yahoo.com
"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: hamcdc_at_yahoo.co.uk
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: ListGuru_at_fatcity.com (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).
Received on Mon Feb 24 2003 - 08:59:00 CST
