SQL> SELECT TO_CHAR(3000, '$0,000.00') 2 FROM dual;TO_CHAR(3000,'$0,000.00') ------------------------- $3,000.00SQL> SELECT TO_CHAR(3000, '$9,999.00') 2 FROM dual;TO_CHAR(3000,'$9,999.00') ------------------------- $3,000.00SQL> SELECT TO_CHAR(3000, '$9,999.99') 2 FROM dual;TO_CHAR(3000,'$9,999.99') ------------------------- $3,000.00SQL>
三种方式:1,SELECT TO_CHAR(3000, '$0,000.00') FROM dual;2,SELECT TO_CHAR(3000, '$9,999.00') FROM dual;3,SELECT TO_CHAR(3000, '$9,999.99') FROM dual;
select to_char('3000', '$9,999.99') from dual
别哥,有点问题啊! 这样验证:SQL> select to_char(3000,'$9999,9999.99') aa from dual;AA -------------- $3000.00SQL> select to_char(3000,'$0000,0000.00') aa from dual;AA -------------- $0000,3000.00 --->这里数字前面出现0SQL> 所以应该用select to_char(3000,'$9999,9999.99') aa from dual; 最有把握
应该是只有两种:SQL> select to_char(3000,'$999,999.99') aa from dual;AA ------------ $3,000.00SQL> select to_char(3000,'$999,999.00') aa from dual;AA ------------ $3,000.00SQL> select to_char(3000,'$000,000.00') aa from dual;AA ------------ $003,000.00--->这种是不对的SQL>
2 FROM dual;TO_CHAR(3000,'$0,000.00')
-------------------------
$3,000.00SQL> SELECT TO_CHAR(3000, '$9,999.00')
2 FROM dual;TO_CHAR(3000,'$9,999.00')
-------------------------
$3,000.00SQL> SELECT TO_CHAR(3000, '$9,999.99')
2 FROM dual;TO_CHAR(3000,'$9,999.99')
-------------------------
$3,000.00SQL>
FROM dual;2,SELECT TO_CHAR(3000, '$9,999.00')
FROM dual;3,SELECT TO_CHAR(3000, '$9,999.99')
FROM dual;
select to_char('3000', '$9,999.99') from dual
这样验证:SQL> select to_char(3000,'$9999,9999.99') aa from dual;AA
--------------
$3000.00SQL> select to_char(3000,'$0000,0000.00') aa from dual;AA
--------------
$0000,3000.00 --->这里数字前面出现0SQL> 所以应该用select to_char(3000,'$9999,9999.99') aa from dual;
最有把握
------------
$3,000.00SQL> select to_char(3000,'$999,999.00') aa from dual;AA
------------
$3,000.00SQL> select to_char(3000,'$000,000.00') aa from dual;AA
------------
$003,000.00--->这种是不对的SQL>