Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

European Number Formatting

440722Mar 1 2006 — edited Mar 1 2006
I am trying to format a number using SQL so that it is displayed with European "delimiters": where the comma and period our reversed.

So if I have a NUMBER field in the database that is: 12345678.90
Rather than using:
SELECT TO_CHAR(12345678.90,'999,999,999,990.00')
FROM DUAL;
and getting: 12,345,678.90

I wanted to know if there is a way to use TO_CHAR to return: 12.345.678,90
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 29 2006
Added on Mar 1 2006
4 comments
3,147 views