From jlewis@punchnetworks.com Mon, 01 Oct 2001 15:06:07 -0700 From: John Lewis Date: Mon, 01 Oct 2001 15:06:07 -0700 Subject: RE: For i (Select..) Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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 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@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@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@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@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@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@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).