Re: number format

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Fri, 06 May 2005 12:53:33 +0200
Message-ID: <d5fi3l$3r8$1@news1.zwoll1.ov.home.nl>

chudi67 wrote:
> Can anyone please explain to me why i can't get a real number with a
> long string.
>
> select to_number('9999911444984599','99999999999999999999999') a from
> dual;
>
> select to_number('9999911444984599',99999999999999999999999) a from
> dual;
>
> select to_number(9999911444984599,99999999999999999999999) a from dual;
>
>
> I am trying to load a long number with sqlloader. It keeps on
> converting to a sccientific notation like this 9,9999E+15.
>
> What do i have to set in sqlloader to get it correctly. Would very much
> appreciate an answer. The filetype is csv and the datatype is
> number(30).
>
> Thanks
> Chudi
>

no it does not.

Storage and display are two different things!!! Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.6.0 - Production

SQL> select to_number('9999911444984599',99999999999999999999999) from dual;

TO_NUMBER('9999911444984599',99999999999999999999999)
-----------------------------------------------------
                                           9.9999E+15

SQL> set numwidth 30
SQL> /

TO_NUMBER('9999911444984599',99999999999999999999999)
-----------------------------------------------------
                                     9999911444984599

basic, very basic!
Oracle <> M$ Excel

-- 
Regards,
Frank van Bortel

Received on Fri May 06 2005 - 05:53:33 CDT