1Z0-051 QUESTION 5 TO_CHAR的应用

最新推荐文章于 2014-05-12 01:08:47 发布

原创最新推荐文章于 2014-05-12 01:08:47 发布 · 501 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

OCP之路专栏收录该内容

37 篇文章

订阅专栏

本文详细探讨了在SQL环境中使用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