Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- VARIABLE g_purchase_num NUMBER(3)
- BEGIN
- g_purchase_num := 500;
- END
- DECLARE
- lv_rating CHAR (4);
- BEGIN
- IF :g_purchase_num > 200 THEN
- lv_rating := ‘HIGH’;
- ELSEIF :g_purchase_num < 200 AND :g_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