FOR I in 1..4 LOOP
IF I=2 THEN
null;
ELSE
DBMS_OUTPUT.PUT_LINE('value of I is ' || I);
END IF;
END LOOP;

-----Original Message-----
From: Abhishek.Goel
[mailto:oracledba-ezmlmshield-x8827587.[Email address protected]
Sent: Wednesday, August 02, 2006 2:53 PM
To: LazyDBA Discussion
Subject: basic question for loop


Hi All

I have one basic question..
I have one FOR LOOP and want to goto start of loop for next value of I, NOTE: I am not suppose to use GOTO statement.

FOR I in 1..4 LOOP
IF I=2 THEN
<< here I want to go to start of loop for next value of I>>
ELSE
DBMS_OUTPUT.PUT_LINE('value of I is ' || I);
END IF;
END LOOP;


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html



"MMS <firsthealth.com>" made the following annotations.
------------------------------------------------------------------------------
This message, including any attachments, is intended solely for the use of the named recipient(s) and may contain confidential and/or privileged information. Any unauthorized review, use, disclosure or distribution of this communication(s) is expressly prohibited. If you are not the intended recipient, please contact the sender by
reply e-mail and destroy any and all copies of the original message.
==============================================================================


Oracle LazyDBA home page