If statement and scalar variable

PL/SQL |

290 B

None

0 👍

0 👎

Raw Download Clone Embed Print View

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;
/

Comments

01/01/70 12:00:00 AM UTC
Plain Text |
0 B
|
👍
/
👎
01/01/70 12:00:00 AM UTC
Plain Text |
0 B
|
👍
/
👎

Pasted

If statement and scalar variable

Comments