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.

Convert Character Values to Number

189123Oct 26 2022 — edited Oct 26 2022

Hello,
I have data in the below format, how I would be able to convert to proper number format in order to use greater or less than functions? When I tried with the below, getting ORA-01722: invalid number
select to_char(attribute_val,'9999999') from test_data
784.185
203.084
601.730
89.018
5,738.996
1,893.208
564.122
40,791.420
210.605

This post has been answered by BluShadow on Oct 26 2022

Jump to Answer

Added on Oct 26 2022

14 comments

1,871 views

3 mentions