Advertisement
jbonanno

Loop Block

Jul 11th, 2017
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.28 KB | None | 0 0
  1. DECLARE
  2. lv_item_price NUMBER (2,2) = 4.50;
  3. lv_items_num    NUMBER (2);
  4. BEGIN
  5. LOOP
  6. DBMS_OUTPUT.PUT_LINE(lv_items_num);
  7. DBMS_OUTPUT.PUT_LINE(lv_item_price);
  8. EXIT WHEN item_price >= 20;
  9. lv_items_num := lv_items_num + 1;
  10. lv_item_price := lv_item_price + lv_item_price;
  11.  
  12. END LOOP;
  13. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement