Total purchase = host variable

PL/SQL |

330 B

None

0 👍

0 👎

Raw Download Clone Embed Print View

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;

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

Total purchase = host variable

Comments