(原发表于2010-12-24)
最先答对且答案未经编辑的puber将获得纪念章一枚(答案不可编辑但可发新贴补充或纠正),其他会员如果提供有价值的分析、讨论也可获得纪念章一枚。
以往旧题索引:
http://www.itpub.net/forum.php?m ... eid&typeid=1808
原始出处:
http://www.plsqlchallenge.com/
作者:MikeB
运行环境:SQLPLUS, SERVEROUTPUT已打开
注:本题给出答案时候要求给予简要说明才能得到奖品
这个代码块执行之后屏幕上会输出什么?
DECLARE
the_text VARCHAR2 (100);
BEGIN
DECLARE
todays_date DATE := TO_DATE ('241210', 'DDMMRR');
BEGIN
CASE TO_NUMBER (TO_CHAR (todays_date, 'DD'))
WHEN 23
THEN
the_text := 'Not yet Xmas';
WHEN 25
THEN
the_text := 'Xmas day';
END CASE;
the_text := 'Santa is coming (for some, sort of, maybe)';
EXCEPTION
WHEN OTHERS
THEN
the_text := 'Today is the 24th';
END;
DBMS_OUTPUT.put_line (the_text);
END;
(A)
Not yet Xmas
(B)
Xmas day
(C)
Santa is coming (for some, sort of, maybe)
(D)
Today is the 24th
|