1Z0-051 QUESTION 5 TO_CHAR的应用

QUESTION 5
Which SQL statements would display the value 1890.55 as $1,890.55? (Choose three .)
A. SELECT TO_CHAR(1890.55,'$0G000D00')
FROM DUAL;
B. SELECT TO_CHAR(1890.55,'$9,999V99')
FROM DUAL;
C. SELECT TO_CHAR(1890.55,'$99,999D99')
FROM DUAL;
D. SELECT TO_CHAR(1890.55,'$99G999D00')
FROM DUAL;
E. SELECT TO_CHAR(1890.55,'$99G999D99')

FROM DUAL;

答案：ADE

解析：

SQL> --A选项能正常显示$1,890.55
SQL> SELECT TO_CHAR(1890.55,'$0G000D00')
  2  FROM DUAL;

TO_CHAR(18
----------
 $1,890.55

SQL> SELECT TO_CHAR(1890.55,'$9,999V99')
  2  FROM DUAL;

TO_CHAR(1
---------
 $1,89055

SQL> --B选项显示不正确
SQL> SELECT TO_CHAR(1890.55,'$9,999V99')
  2  FROM DUAL;

TO_CHAR(1
---------
 $1,89055

SQL> --C选项直接报错
SQL> SELECT TO_CHAR(1890.55,'$99,999D99')
  2  FROM DUAL;
SELECT TO_CHAR(1890.55,'$99,999D99')
                       *
第 1 行出现错误:
ORA-01481: 无效的数字格式模型


SQL> --D选项能正常显示$1,890.55

SQL> SELECT TO_CHAR(1890.55,'$99G999D00')
  2  FROM DUAL;

TO_CHAR(189
-----------
  $1,890.55

SQL> --E选项能正常显示$1,890.55
SQL> SELECT TO_CHAR(1890.55,'$99G999D99')
  2  FROM DUAL;

TO_CHAR(189
-----------
  $1,890.55