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

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的格式，G代表的是,D代表的是.可以通过查看NLS_NUMBERIC_CHARACTER参数来确定他们表示的是什么
A.正确
B.错误，V表示的是返回乘以10的x次方的结果，其中x是v之后9的个数，比如下面的这个
SQL>   select to_char(1234,'9999V99') from dual;
TO_CHAR
-------
 123400
SQL>   
C.错误，符号和字母不能混用
D.正确
E.正确