Live ORACLE

DECLARE

  total    NUMBER(9) := 0;

   counter  NUMBER(6) := 0;

BEGIN

  LOOP

    counter := counter + 1;

   

    total := total + counter * counter;

   

    -- exit loop when condition is true

    EXIT WHEN total > 25000;

  END LOOP;

 

  dbms_output.Put_line('Counter: '

                       ||To_char(counter)

                       ||' Total: '

                       ||To_char(total));

END;

/

Using the EXIT-WHEN Statement