IF-THEN-ELSE example
DECLARE v_out VARCHAR2(50); v_num NUMBER:=-7; BEGIN IF v_num = 0 THEN v_out := 'The value: '||v_num; ELSIF v_num > 0 THEN v_out := 'The value: '||v_num; ELSE v_out := 'The value of num < 0; num = '||v_num; END IF; DBMS_OUTPUT.put_line(v_out); END;
Output:
The value of num < 0; num = -7