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



"Abhishek.Goel " <oracledba-ezmlmshield-x8827587.[Email address protected]
08/02/2006 05:53 PM

To
"LazyDBA Discussion" <[Email address protected]
cc

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




----------------------------------------------------------------------
CONFIDENTIALITY STATEMENT. The information contained in this e-mail message, including attachments, is the confidential information of, and/or is the property of, Vanguard. The information is intended for use solely by the individual or entity named in the message. If you are not an intended recipient or you received this in error, then any review, printing, copying, or distribution of any such information is prohibited, and please notify the sender immediately by reply e-mail and then delete this e-mail from your system.

Oracle LazyDBA home page