Re: Problem with TO_NUMBER function

Philippe Aubert (paubert_at_mais.hydro.qc.ca) wrote:
> Environment : Oracle 7.0.15.4.0 under Solaris 2.3
> Sqlplus 3.1.2.3.1

> I got a problem with numbers lower than 1 :
> SQL> select to_number(.030,'90.99') from dual;
> ERROR:
> ORA-01722: Invalid Number

The format 90.99 is wrong.
Try 09.99 instead.

> SQL> select to_number(.030,'99.09') from dual;
>
> TO_NUMBER(.030,'99.00')
> -----------------------
> .03
 

> SQL> select to_number(1.030,'90.99') from dual;
>
> TO_NUMBER(1.030,'90.99')
> ------------------------
> 1.03

Just the same.

So long,

                Dirk.

--
Dirk Moebius                      moebius_at_athene.informatik.uni-bonn.de