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?
Printable View
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?
I'm not sure of exactly what you are trying to do, but the following statement will work:
select to_char(to_number('0.24'), 'FM0.99') from dual;
HTH.Code:sql> select to_number('0.24') from dual;
TO_NUMBER('0.24')
-----------------
.24
Elapsed: 00:00:00.00
sql> set numformat 0.99
sql> select to_number('0.24') from dual;
TO_NUMBER('0.24')
-----------------
0.24
Elapsed: 00:00:00.00
sql>