plsql 条件判断语句

-- begin exception end

begin
        dbms_output.put_line('');

exception
        when no_data_found then
            dbms_output.put_line('');
end;

-- IF
IF condition THEN

         {...statements...}

END IF;

-- IF-THEN-ELSE

IF condition THEN

         {...statements...}

ELSE

         {...statements...}

END IF;

-- IF-THEN-ELSIF

IF condition THEN

         {...statements...}

ELSIF condition THEN

         {...statements...}

ELSE

         {...statements...}

END IF;