number format

From: chudi67 <chudi67_at_yahoo.com>
Date: 6 May 2005 03:28:01 -0700
Message-ID: <1115375281.484940.198680@g14g2000cwa.googlegroups.com>

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 - 05:28:01 CDT