数字转换为字符串时，如何保留小数点前面的0?????

Question

select to_char(0.12345678) A from dual
结果 A
     .12345678我要的是0.12345678
如何才能实现???????????????????????

Answer 1

不知道补零的方式，适不适合楼主
select decode(substr(to_char(0.12345678), 1, 1), '.', '0', '') ||
       to_char(0.12345678) a
  from dual

Answer 2

select to_char(0.12345678,'0.99999999') A from dual

Answer 3

SQL> select rtrim(to_char('100.123','FM999999990.9999'),'.') "col1",
  2         rtrim(to_char('0.456','FM999999990.9999'),'.') "col2"
  3  from dual
  4  ;
 
col1            col2
--------------- ---------------
100.123         0.456
 
SQL> 

Answer 4

select cast(0.123456789 as number ) from dual

Answer 5

如果只是缺少前面 0 的话，可以投机取巧一下
select '0'||to_char(0.12345678) A from dual;

Answer 6

select to_char(0.12345678, 'FM0.00000000') A from dual

Answer 7

select to_char(0.12345678, 'fm999990.999999999') from dual;

Answer 8

select to_char(0.12345678,'0.99999999') A from dual