plsql IF-THEN-ELSE Statement IF-THEN
Example
DECLARE
v_num1 NUMBER(10);
v_num2 NUMBER(10);
BEGIN
v_num1 := 2;
v_num2 := 1;
IF v_num1 > v_num2 THEN
dbms_output.put_line('v_num1 is bigger than v_num2');
END IF;
END;
DECLARE
v_num1 NUMBER(10);
v_num2 NUMBER(10);
BEGIN
v_num1 := 2;
v_num2 := 1;
IF v_num1 > v_num2 THEN
dbms_output.put_line('v_num1 is bigger than v_num2');
END IF;
END;
