Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Exit condition in loop

BraamOct 12 2012 — edited Oct 12 2012
I am putting exit condition in before and after my business logic, so it make any difference
BEGIN
	FOR REC IN 1..10
	LOOP
		EXIT WHEN REC =5;
		/*
		business logic
		*/
	END LOOP;
END;
BEGIN
	FOR REC IN 1..10
	LOOP
		/*
		business logic
		*/
		EXIT WHEN REC =5;
	END LOOP;
END;
Thanks

Edited by: Braam on Oct 11, 2012 10:24 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 9 2012
Added on Oct 12 2012
5 comments
391 views