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
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
Explanation:
999表示宽度 G表示分组分隔符 D表示逗号分隔符 V表示移动n位（小数点）乘以10的n次方
其中E格式错误，因为， 不能和D同时存在。，要用分隔符G表示
扫一扫
9218
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
