ocp 11g考試題庫詳解：1Z0-051-089題，完整題庫請點(diǎn)擊這里聯(lián)系老師咨詢了解

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')) 錯(cuò)。

FROM DUAL;

Answer: C

試題解析：

A錯(cuò)誤，'11-oct-2007'本來就是字符，就不用再to_char

B中'fmDdspth of month, year'的of需要用雙引號(hào)引起來。

C正確。

D跟A一樣的錯(cuò)誤，'11-oct-2007'本來就是字符，就不用再to_char。