OCP 11g考试题库详解：1Z0-051-089题

OCP 11g考试题库详解：1Z0-051-089题，完整题库请点击这里联系老师咨询了解

89. You need to display the date 11-oct-2007 in words as 'Eleventh of October, Two Thousand Seven'.

Which SQL statement would give the required result?

A. SELECT TO_CHAR('11-oct-2007', 'fmDdspth "of" Month, Year')

FROM DUAL;

B. SELECT TO_CHAR(TO_DATE('11-oct-2007'), 'fmDdspth of month, year')

FROM DUAL;

C. SELECT TO_CHAR(TO_DATE('11-oct-2007'), 'fmDdthsp "of" Month, Year')

FROM DUAL;

D. SELECT TO_DATE(TO_CHAR('11-oct-2007','fmDdspth ''of'' Month, Year')) 错。

FROM DUAL;

Answer: C

试题解析：

A错误，'11-oct-2007'本来就是字符，就不用再to_char

B中'fmDdspth of month, year'的of需要用双引号引起来。

C正确。

D跟A一样的错误，'11-oct-2007'本来就是字符，就不用再to_char。