Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE
- lv_purchase_num NUMBER (3);
- lv_rating CHAR (4);
- BEGIN
- IF lv_purchase_num > 200 THEN
- lv_rating := ‘HIGH’;
- ELSEIF lv_purchase_num < 200 AND lv_purchase_num > 100 THEN
- lv_rating := ‘MID’;
- ELSE
- lv_rating := ‘LOW’;
- END IF;
- DBMS_OUTPUT.PUT_LINE(lv_rating);
- END;
- /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement