如何格式化输出的数字

[dacsd]

如SQL语句输出的数字为
.0123,1.234等等，如何将.123输出为0.123

[guolibin]

select to_char(0.1,'90.99') from dual;

[kulama2004]

select to_char( .123, '0.000' ) from dual;

[沝林]

select to_char(0.123,'0.999') from dual

0.123

select to_char(0.123,'0.9999') from dual

0.1230

[辉说慧语]

mark