OCP-1Z0-新051-61题版本-9

QUESTION NO: 9

Which three SQL statements would display the value 1890.55 as $1,890.55? (Choose three.)

A.SELECT TO_CHAR(1890.55,'$99G999D00') FROM DUAL;

B.SELECT TO_CHAR(1890.55,'$9,999V99') FROM DUAL;

C.SELECT TO_CHAR(1890.55,'$0G000D00') FROM DUAL;

D.SELECT TO_CHAR(1890.55,'$99G999D99') FROM DUAL;

E.SELECT TO_CHAR(1890.55,'$9,999D99') FROM DUAL;

Answer: A,C,D

答案解析：

参考：5：http://blog.csdn.net/rlhua/article/details/12910027