1Z0-051 QUESTION 5 TO_CHAR的应用

来源：互联网发布：唯品会抢购神器软件编辑：程序博客网时间：2024/05/21 12:39

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.55SQL> SELECT TO_CHAR(1890.55,'$0G000D00')  2  FROM DUAL;TO_CHAR(18---------- $1,890.55SQL> SELECT TO_CHAR(1890.55,'$9,999V99')  2  FROM DUAL;TO_CHAR(1--------- $1,89055SQL> --B选项显示不正确SQL> SELECT TO_CHAR(1890.55,'$9,999V99')  2  FROM DUAL;TO_CHAR(1--------- $1,89055SQL> --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.55SQL> SELECT TO_CHAR(1890.55,'$99G999D00')  2  FROM DUAL;TO_CHAR(189-----------  $1,890.55SQL> --E选项能正常显示$1,890.55SQL> SELECT TO_CHAR(1890.55,'$99G999D99')  2  FROM DUAL;TO_CHAR(189-----------  $1,890.55

0 0