'Transform differents decimal number in one format decimal [duplicate]

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

sqloracledecimaltransformation


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions