Skip to Main Content

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!

Format number - comma as decimal separator

user560737Nov 14 2019 — edited Nov 14 2019

Hello

I would not like to use REPLACE

How can to_number a string with comma (as decimal)

select  to_number(12345,67') as numb1 from dual;

maybe with NLS_NUMERIC_CHARACTER

Thanks in advance

This post has been answered by Anton Scheffer on Nov 14 2019
Jump to Answer
Comments
Post Details
Added on Nov 14 2019
5 comments
16,274 views