Oracle 19c.
I am reading a file and need to store the following values into a NUMBER column:
000036720
000008425
000754070
000086640
000001645
Desired output will be:
367.20
84.25
7540.70
866.40
16.45
I can use SUBSTR(), but was wondering if there is a better/easier approach. I played with TO_CHAR(), but can’t seem to find a mask I need.