0

I have different numbers of the type and I want to transform them in the following way:

    3.070,44   => 3070.44
    935907.44  => 935907.44 (good format so no transformation)
    96,42      => 96.42
    4.614,22   => 4614.22
    00,00      => 00.00
   2349.21-    =>2349.21 
   3248,98-    =>3248.98

How can I perform the transformations in Oracle Sql with a query?

thank you in advance for your help

Juji
  • 11
  • 2
  • with data as ( select '3.070,44' as val from dual union all select '935907.44' as val from dual union all select '96,42' as val from dual union all select '4.614,22' as val from dual union all select '00,00' as val from dual union all select '2349.21-' as val from dual union all select '3248,98-' as val from dual ) select to_number(translate(val, '0123456789' || val, '0123456789'))/100 as num from data; NUM ---------- 3070.44 935907.44 96.42 4614.22 0 2349.21 3248.98 – Pugzly Apr 07 '22 at 05:59

0 Answers0