DevOps, CI/CD and Automation

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!

Decimal and thousands separator

609796Nov 21 2007 — edited Nov 26 2007

Hello everyone. I have a problem regarding the decimal separator in a number. What I need to do is change the decimal separator "." with a comma "," and the thousands separator "," with a dot "." (that is exchange the decimal separator with the thousands separator).
Meaning that 1,000 would be 1.000 and 0.5 would be 0,5.
I thought of solving this problem with a Format Trigger but I'm not very familiar with it so I'd really appreciate some help.
Thanks in advance!