oracle程序设计之if判断

if判断

if 条件 then 结果 end if

select * from emp;

DECLARE
    v_sal NUMBER;
BEGIN
    SELECT
        sal
    INTO v_sal
    FROM
        emp
    WHERE
        ename = '王嘻嘻2';

    IF v_sal < 2000 THEN
        dbms_output.put_line('努力');
    END IF;
END;


DECLARE
    v_sal NUMBER;
BEGIN
    SELECT
        sal
    INTO v_sal
    FROM
        emp
    WHERE
        ename = '王嘻嘻2';

    IF v_sal < 1000 THEN
        dbms_output.put_line('努力');
    ELSE
        dbms_output.put_line('很棒');
    END IF;

END;



DECLARE
    v_sal NUMBER;
BEGIN
    SELECT
        sal
    INTO v_sal
    FROM
        emp
    WHERE
        ename = '王嘻嘻2';

    IF v_sal < 1000 THEN
        dbms_output.put_line('努力');
    ELSif v_sal >=  500 then
        dbms_output.put_line('很棒');
    END IF;

END;


DECLARE
    v_sal NUMBER;
BEGIN
    SELECT
        sal
    INTO v_sal
    FROM
        emp
    WHERE
        ename = '王嘻嘻2';

    IF v_sal < 500 THEN
        dbms_output.put_line('努力');
    ELSIF
        v_sal > 500
        AND v_sal < 2000
    THEN
        dbms_output.put_line('可以');
    ELSIF v_sal > 2000 THEN
        dbms_output.put_line('可以');
    END IF;

END;




DECLARE
    v_sal NUMBER;
BEGIN
    SELECT
        sal
    INTO v_sal
    FROM
        emp
    WHERE
        ename = '王嘻嘻2';

    case when v_sal < 500 THEN
        dbms_output.put_line('努力');
    case when
        v_sal > 500
        AND v_sal < 2000
    THEN
        dbms_output.put_line('可以');
    case when v_sal > 2000 THEN
        dbms_output.put_line('可以');
    END case;

END;