PLSQL Language Referenc-PL/SQL控制語句-條件選擇語句-簡單CASE

CASE selector

WHEN selector_value_1 THEN statements_1

WHEN selector_value_2 THEN statements_2

...

WHEN selector_value_n THEN statements_n

[ ELSE

    else_statements ]

END CASE;]

DECLARE

    grade CHAR(1);

BEGIN

    grade := 'B';

    CASE grade

        WHEN 'A' THEN DBMS_OUTPUT.PUT_LINE('優秀');

        WHEN 'B' THEN DBMS_OUTPUT.PUT_LINE('良好');

        WHEN 'C' THEN DBMS_OUTPUT.PUT_LINE('好');

        WHEN 'D' THEN DBMS_OUTPUT.PUT_LINE('及格');

        WHEN 'F' THEN DBMS_OUTPUT.PUT_LINE('不及格');

        ELSE DBMS_OUTPUT.PUT_LINE('沒有該等級');

    END CASE;

END;