Wednesday, 15 May 2013

plsql - How do you convert a varchar2 into a number with two decimal places? -


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