"Problem solved" does not show a 0 problem before the decimal point

problem Description java when reading Oracle database data, if Oracle storage is a decimal, between ( -1,1), the preceding 0 is not displayed, such as: 0.1214 will read as ". 1214", in the example: "0.3423" will read as "-." 3423 ".

solution in order to solve the Java read for "0.112" instead of ". 112", you can modify the database query statement. By the original:

  
  
 

   
   
  
select t.num from tableA t; ==>查询结果为：.112 
  
  
 

Modified to:

  
  
 

   
   
  
select to_char(t.num,‘fm999999990.999999999‘) from tableA t; ==>查询结果为：0.112 
  
  
 

From for notes (Wiz)

"Problem solved" does not show a 0 problem before the decimal point