Sorry, I'm new to Oracle and I'm having some problems, which are in a table, which are
varchar2 . I need to be number with 2 decimal places.
For example:
00008600 00202033 00094123 should be
86.00 2020.33 941.23 How can I do this? You can use something like this:
To_char (to_number (yourcol) / 100.0, 9999999d99 ') Your code is formatted with your table View
No comments:
Post a Comment