if i do:
SQL> select to_number('0.24') from dual;

TO_NUMBER('0.24')
-----------------
.24


it show .24, but i want to show 0.24, how to?