I have a character coming in the file 1234567891011.92518-,
I wanted to convert into a number in oracle and move the - sign to the front
where A.xxxx_AMT = 1234567891011.92518-
CASE WHEN SUBSTR(A.xxxx_AMT,-1,1) = '-'
THEN TO_NUMBER(SUBSTR(A.xxxx_AMT,1,LENGTH(A.xxxx_AMT) -1)) * -1
END AS xxxx_AMT
the result I expected was -1234567891011.92518
but I am getting this -1234567891011.93