Oracle Database Discussions

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!

Thousands and Millions Separator in TO_NUMBER

User_B4K0FJun 19 2014 — edited Jun 19 2014

Hi all,

I have a question about the separator for thousands and millions in oracle SQL,

We usually use to_number('52420.87', '999G999G999D99', 'NLS_NUMERIC_CHARACTERS=''.,''') to convert text to a number and in my ca.

My problem is to use that formula my string should have the comma (,) as a separator for thousands and millions... (the point (.) is for decimal witch is GOOD because my strings are all of the format 999999.99)

So I need to specify NULL (or no character) as the thousands separator. is there any possibility?

Another solution is to format my text to have the form as 999,999,999.99

please post any suggestion.

Thanks for help

Best Regards.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 17 2014

Added on Jun 19 2014

#general-database-discussions

2 comments

8,038 views