IF-THEN-ELSIF

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