jbonanno icon

Loop Block

jbonanno | PRO | 07/12/17 04:42:37 AM UTC | 0 ⭐ | 7332 👁️ | Never ⏰ | []
PL/SQL |

280 B

|

None

|

0 👍

/

0 👎

DECLARE 
lv_item_price NUMBER (2,2) = 4.50;
lv_items_num    NUMBER (2);
BEGIN
LOOP
DBMS_OUTPUT.PUT_LINE(lv_items_num);
DBMS_OUTPUT.PUT_LINE(lv_item_price);
EXIT WHEN item_price >= 20;
lv_items_num := lv_items_num + 1;
lv_item_price := lv_item_price + lv_item_price;
 
END LOOP;
END;

Comments

  •  icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    👍

    /

    👎

    
        
  •  icon
    01/01/70 12:00:00 AM UTC
    Plain Text |

    0 B

    |

    👍

    /

    👎