IF-THEN-ELSE

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