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!

number convert with to_char

dusooMar 13 2009 — edited Mar 13 2009

Hi guys,
could you please help me coverting one number with ',' to number with '.' ?

convert number from
5,323
0,252
9476

to
5.323
0.252
9476

I have tried to_char(numbers,'fm9999999990d999', 'NLS_NUMERIC_CHARACTERS = ''.,''')
But im getting '.' also for number where i should not have one = "9476."
Cant find any help how to handle this.
Thanks a lot

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 10 2009

Added on Mar 13 2009

7 comments

420 views