Hi,
I am having a little problem formatting numbers. All numbers should be converted to a string (I use UTL_FILE.PUT_FILE) and have the same format.
Decimale sepatator = comma ,
For example:
0.1775 -> 0,1775
-0.1775 -> -0,1775
1.15 -> 1,15
-1.4785 -> -1.4785
26597.4785 -> 26597,4785
SQL> CREATE TABLE TEST_FORMAT(TST NUMBER);
Table created.
SQL> INSERT INTO TEST_FORMAT VALUES(0.1775);
1 row created.
SQL> INSERT INTO TEST_FORMAT VALUES(-0.1775);
1 row created.
SQL> INSERT INTO TEST_FORMAT VALUES(1.15);
1 row created.
SQL> INSERT INTO TEST_FORMAT VALUES(-1.4785);
1 row created.
SQL> INSERT INTO TEST_FORMAT VALUES(26597.4785);
1 row created.
SQL> COMMIT;
Commit complete.
I know I have to use a number format like:
SELECT REPLACE(TO_CHAR(TST,'0D9999'),'.',',') FROM TEST_FORMAT
-> works for numbers < 1
SELECT REPLACE(TO_CHAR(TST,'99999D9999'),'.',',') FROM TEST_FORMAT
-> works for numbers > 1
But I would like to see 1 format for all numbers. Any suggestions?