Hrm, did it on 8i and 8.0.5 and got the same result.
<font face="courier">
SQL> select to_number('54.12', '99.99') from dual;
TO_NUMBER('54.12','99.99')
--------------------------
54.12
SQL> c/54.12/,
1* select to_number(',', '99.99') from dual
SQL> /
TO_NUMBER(',','99.99')
----------------------
0
SQL>
</font>




Reply With Quote