IF-THEN

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