RE: For i (Select..)

From: John Lewis <jlewis_at_punchnetworks.com>
Date: Mon, 01 Oct 2001 15:06:07 -0700
Message-ID: <F001.0039E166.20011001151528@fatcity.com>

The 'For I in...' is an implicit cursor

To define/declare a cursor is explicit.

I've used both. The 'For i in...' is down, dirty and very fast.

-----Original Message-----
Sent: Monday, October 01, 2001 3:50 PM
To: Multiple recipients of list ORACLE-L

the code IS a cursor

• Csillag Zsolt <starsoft_at_interware.hu> wrote:
  >
  >
  > Hi,
  >
  >
  > I've read in Tom Kyte's book the following technique:
  >
  >
  > For i in (Select statement ) Loop
  >
  > Process records here
  >
  > End Loop ;
  >
  > I have tried it and it works great.
  >
  > The question is that what is the difference betwen a cursor and the
  > code above?
  > Which is more efficient?
  >
  > Thank you
  >
  >
  > Zsolt Csillag
  > Hungary
  >
  > --
  > Please see the official ORACLE-L FAQ: http://www.orafaq.com
  > --
  > Author: Csillag Zsolt
  > INET: starsoft_at_interware.hu
  >
  > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
  > San Diego, California -- Public Internet access / Mailing
  > Lists
  > --------------------------------------------------------------------
  > 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).
  

  ---

Do You Yahoo!?
Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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.com
-- 
Author: John Lewis
  INET: jlewis_at_punchnetworks.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Oct 01 2001 - 17:06:07 CDT