IF-THEN-ELSIF example
DECLARE v_out VARCHAR2(50); v_num NUMBER:=8; v_name VARCHAR2(100):='XYZ'; BEGIN IF v_num = 2 THEN NULL; ELSIF v_num = 8 THEN v_out := 'The value: '||v_num; DBMS_OUTPUT.put_line(v_out); END IF; IF v_name = '123' THEN NULL; ELSIF v_name = 'XYZ' THEN DBMS_OUTPUT.put_line(v_name); END IF; END;
Output:
The value: 8
XYZ