Live ORACLE

if you are Oracle Developer ,than this Blog most likely will make you happy.

About my Blog

This Blog particularized for Oracle Developers ... you will see interesting Codes for SQL , PL/SQL as well as new ideas for Developer Suite and Client Tools that will help you in your professional life ... and I hope I reach for your satisfaction.

About Me

I'm Hany Freedom , 25 years old , I live in EL-Minia City in Egypt , I'm Moderator at ArabOUG.org the best Arabic Forum for ORACLE on the Net. if you interested to know more about me .... just Click Here.

Using EXIT With a Label in a LOOP


DECLARE

v_employees employees%ROWTYPE; -- declare record variable

CURSOR c1 IS

SELECT *

FROM employees;

BEGIN

OPEN c1; -- open the cursor before fetching



-- An entire row is fetched into the v_employees record

<<outer_loop>>

FOR i IN 1.. 10 LOOP

-- process data here

FOR j IN 1.. 10 LOOP

FETCH c1 INTO v_employees;



EXIT WHEN c1%NOTFOUND;

-- process data here

END LOOP;

END LOOP outer_loop;



CLOSE c1;

END;

/



Share/Save/Bookmark

0 comments:

Post a Comment



Newer Posts Older Posts Home Page
 
http://www.dpriver.com/images/sqlpp-banner-2.png

Thanks for reading my Blog ... you Visitor Number :-