Analysis of problems based on Oracle decimal 0 loss _oracle

1. The origin of the problem
When the Oracle database field value is less than 1 decimal, processing with the char type loses 0 of the preceding decimal point
For example, 0.35 becomes. 35

2. Solution: Format digital display with To_char function
Select To_char (0.338, ' fm9999999990.00 ') from dual;
Results: 0.34
The focus here is to see fm9999999999.99, which means that the integer part is up to 10 bits, the decimal part is 2 BITS, FM means to remove the front space after the turn string, without adding fm,0.34 before there will be spaces.