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 -> loop

loop

From: Stjepan Brbot <stjepan.brbot_at_zg.hinet.hr>
Date: Sat, 3 Aug 2002 00:06:03 +0200
Message-ID: <aifov4$3c8u$4@as201.hinet.hr>


What is better:

FOR xy IN curXY LOOP

...

END LOOP; or

OPEN curXY;
LOOP
    FETCH curXY INTO xy;
    IF curXY%NOTFOUND THEN

        EXIT;
    END IF;
...

END LOOP;

-- 

Stjepan Brbot
Received on Fri Aug 02 2002 - 17:06:03 CDT

Original text of this message

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