pl/sql的case语句总结

清晰版：

-----------------------------------------------------------------------------------------------

-----------------------------------------------------------------------------------------------

-----------------------------------------------------------------------------------------------

-----------------------------------------------------------------------------------------------

复制版：

--case表达式中的简单case

DECLARE 
v_num    NUMBER :=#
v_result VARCHAR2(30);
BEGIN
v_result := MOD(v_num,2);
dbms_output.put_line
(
CASE v_result
    WHEN 0 THEN 'the number you input is :even'
    ELSE        'the number you input is :odd'
END   
);--作为一输出v_result的语句
END;

------------------------------------------------------------------------------------------

--搜索式的case表达式
DECLARE
v_num    NUMBER := &n;
v_result NUMBER;
BEGIN
v_result := MOD(v_num,2);
dbms_output.put_line
(
CASE 
    WHEN v_result=0 THEN '您输入的是:偶数 ！'
    WHEN v_result = 1 THEN '您输入的是:奇数 ！'
    END
);
END;

------------------------------------------------------------------------------------------

--搜索式case语句

SET SERVEROUTPUT ON;
DECLARE
v_num1  NUMBER := &n;
BEGIN
CASE 
    WHEN MOD(v_num1,2) = 0 THEN dbms_output.put_line('您输入的数是:偶数！');
    WHEN MOD(v_num1,2) = 1 THEN dbms_output.put_line('您输入的数是:奇数！');
    ELSE  dbms_output.put_line('输入错误！');
END CASE;
END;

------------------------------------------------------------------------------------------

-- 简单case语句

SET SERVEROUTPUT ON;
DECLARE
v_num1   NUMBER:=&n;
v_result NUMBER;
BEGIN
v_result := MOD(v_num1,2);
CASE v_result
    WHEN 0 THEN dbms_output.put_line('您输入的数是:偶数！');
    WHEN 1 THEN dbms_output.put_line('您输入的数是:奇数！');
    ELSE   dbms_output.put_line('输入错误！');
END CASE;
END;

------------------------------------------------------------------------------------------