Re: number format

From: Maxim <mdemenko_at_gmail.com>
Date: 6 May 2005 04:20:47 -0700
Message-ID: <1115378447.019939.148440@o13g2000cwo.googlegroups.com>

Hi, the numbers are stored in the database not in the usual notation or scientific notation - they are stored as numbers with scale and precision definied through you column definition ( e.g. number(30)). To get usual representation of number instead of scientifical you should use column formatiing in the sqlplus, e.g.

sys_at_APPL> select

to_number('9999911444984599','99999999999999999999999') numb from dual;

      NUMB

---

9.9999E+15

sys_at_APPL> col numb for 999999999999999999999999

sys_at_APPL> r

  1* select to_number('9999911444984599','99999999999999999999999')

numb from dual

                     NUMB
-------------------------
         9999911444984599

sys_at_APPL>

If you have any problems with loading your data into database, it could be helpful if you post the control file, snippet of your data and table definition.

Best regards

Maxim
chudi67 schrieb:
> 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
Received on Fri May 06 2005 - 06:20:47 CDT