Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PLS/SQL: OK to use EXIT in a cursor FOR LOOP ??

Re: PLS/SQL: OK to use EXIT in a cursor FOR LOOP ??

From: Kenneth C Stahl <kcstahl_at_ix.netcom.com>
Date: Sun, 20 Jun 1999 17:05:39 -0400
Message-ID: <376D57A3.CAFB159@ix.netcom.com> 







Connor McDonald wrote:


> 


> 


> Another nice thing is that you don't even need a cursor...


> 


> for i in ( select my_data, some_more


>            from my_table ) loop


> 


>   blah blah blah


> end loop;


> 


> works quite nicely...


> --





Using that method, how do you access the cursor attributes? %ROWCOUNT
for instance?
Received on Sun Jun 20 1999 - 16:05:39 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US