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;