IF-THEN example
DECLARE v_out VARCHAR2(50); v_num NUMBER:=5; v_name VARCHAR2(100); BEGIN IF v_num = 5 THEN v_out := 'The value: '||v_num; DBMS_OUTPUT.put_line(v_out); END IF; IF v_name IS NULL THEN v_name := 'IF Statement example'; DBMS_OUTPUT.put_line(v_name); END IF; END;
Output:
The value: 5
IF Statement example