I am trying to insert data from a spreadsheet in the bank with fields in a format that contains thousand, hundred and ten example: 1,234.43
The problem is that I have hundreds 234.43 and when I can fix a field It's the problem in another.
When the field does not have the dozen it mixes example: what would be 5.45 it is 5.45
and a thousand that would be 2,765 this 27.65
I already tried several forms but this example I mentioned this way:
SELECT replace(replace(replace(TRIM(TO_CHAR(unit_price,'999,990.00','nls_numeric_characters='',.''')),',','*'),'.',','),'*','.') FROM
If anyone can help thank you because I have tried all the formats I found on the net.
Thanks.