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!

Convert US number format to Europian Number Format

Vikrant_singhApr 8 2014 — edited Apr 8 2014

Hello Experts,

I have a situation in which i need to convert US number format (eg. 10,000.00) to European number format (eg 10.000,00).

for example- if the input is 15,599.00 it should be converted to 15.599,00

if the input is already 15.599,00 nothing should happen.

we can have a function for that.

Please let us know your thoughts.

Thanks,

Vikrant

Locked Post

New comments cannot be posted to this locked post.

Locked on May 6 2014

Added on Apr 8 2014

#plsql

3 comments

2,048 views