Advertisement
jbonanno

case statements and scalar variables

Jul 11th, 2017
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.31 KB | None | 0 0
  1. DECLARE
  2. lv_purchase_num NUMBER (3);
  3. lv_rating CHAR (4);
  4. BEGIN
  5. CASE lv_purchase_num
  6. WHEN  lv_purchase_num > 200  THEN lv_rating  := ‘HIGH’;
  7. WHEN lv_purchase_num < 200 AND lv_purchase_num > 100 THEN  lv_rating  := ‘MID’;
  8. ELSE
  9. lv_rating  := ‘LOW’;
  10. END CASE;
  11. DBMS_OUTPUT.PUT_LINE(lv_rating);
  12. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement