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
考点：to_char(number)
关键字：G

ADE正确

B错误，V后两位表示乘以10的2次方

C 错误,逗号和D不能同时使用

千位分隔符，可以和.一起使用，或者使用G 和 D 表示

ITPub博客

【OCP】Oracle 11g OCP 1Z0-051 005

最新文章