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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
15,996 views