OCP 1Z0 051 5

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; 

SQL> SELECT TO_CHAR(1890.55,'$0G000D00') FROM DUAL;
TO_CHAR(1890.55,'$0G000D00')
----------------------------
 $1,890.55
Executed in 0.015 seconds
SQL> SELECT TO_CHAR(1890.55,'$9,999V99') FROM DUAL;
TO_CHAR(1890.55,'$9,999V99')
----------------------------
 $1,89055
Executed in 0.015 seconds
SQL> SELECT TO_CHAR(1890.55,'$99,999D99') FROM DUAL;
SELECT TO_CHAR(1890.55,'$99,999D99') FROM DUAL
ORA-01481: 无效的数字格式模型
SQL> SELECT TO_CHAR(1890.55,'$99G999D00') FROM DUAL;
TO_CHAR(1890.55,'$99G999D00')
-----------------------------
  $1,890.55
Executed in 0.016 seconds
SQL> SELECT TO_CHAR(1890.55,'$99G999D99') FROM DUAL;
TO_CHAR(1890.55,'$99G999D99')
-----------------------------
  $1,890.55
Executed in 0.016 seconds

SQL> 

要点在于 G V D的用法

D

99D99

Returns in the specified position the decimal character, which is the current value of the NLS_NUMERIC_CHARACTERparameter. The default is a period (.). Restriction: You can specify only one decimal character in a number format model.

G

9G999

Returns in the specified position the group separator (the current value of the NLS_NUMERIC_CHARACTER parameter). You can specify multiple group separators in a number format model. Restriction: A group separator cannot appear to the right of a decimal character or period in a number format model.

V

999V99

Returns a value multiplied by 10n (and if necessary, round it up), where n is the number of 9's after the V.

四舍五入

SQL> select to_char(12.50,'99V') from dual;
TO_CHAR(12.50,'99V')
--------------------
 13
Executed in 0.015 seconds

乘10

SQL> select to_char(12.50,'99V9') from dual;
TO_CHAR(12.50,'99V9')
---------------------
 125
Executed in 0.016 seconds

Answer: ADE