Re: Which is beter a cursor or a for loop?

It's purely syntactical sugar unless you use the BULK features of the explicit cursor, in which case, you may gain some performance.

/Bjørn.

Denham Eva wrote:

> 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
> www.marshalsoftware.com <http://www.marshalsoftware.com>
> ------------------------------------------------------------------------

-- 
Bjørn Engsig, Miracle A/S
Member of Oak Table Network <http://www.oaktable.net>
Bjorn.Engsig@MiracleAS.dk - http://MiracleAS.dk



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?ISO-8859-1?Q?Bj=F8rn_Engsig?=
  INET: bjorn_at_miracleas.dk

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).