Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

looking for help re writing a for-loop

 
Matt Kohanek
Village Idiot
Ranch Hand
Posts: 484
Java jQuery Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hey guys,

Here is the for loop:


I would like the loop to end once the IF statement inside of it evaluates to true (or once v_line_tbl(i).orig_sys_line_ref is no longer NULL, same difference).

I know there is a simple way to accomplish this from the tutorials I used to teach myself pl sql, but I have not found it and cannot remember it.

Can anyone point me in the right direction please?

SOLUTION -

EXIT;

:\

I was trying EXIT LOOP; this whole time and could not fogure out why it was not working hahaha
 
Agador Paloi
Ranch Hand
Posts: 118
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Matt -
you can also code EXIT WHEN conition to accomplish the same thing.


Agad
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!