参考:http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements004.htm#i34510
SELECT TO_CHAR(number, 'fmt')
FROM DUAL;
Table 1-1:Results of Number Conversions
※Ps:
FM:Returns a value with no leading or trailing blanks.
number | 'fmt' | Result |
---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|