I have a table with a column (prod_amount) which is a varchar2.
As you see there is both used , and . as decimal seperator.
select to_number(prod_amount) as mynum;
I get an error "Invalid number"
What is the best way to solve my problem ? I can't replace the , to . in the database.