Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQLLOADER
You can try CHAR in loader script and FLOAT in table.
tu
GERNEZ wrote:
> hello,
>
> I have HP unix and Oracle 8 database, my problem is :
> insert a file (file unix) in a table, in fila file i have five
> columns and one of the column have this format ( -123,4567)
> in my .CTL this column is
> TOTO POSITION(123:150) FLOAT EXTERNAL
> in my table is
> TOTO FLOAT
> I have search with FLOAT,DECIMAL,INTEGER but no result, in my table the
> columns TOTO +AD0- 0 or 1,3E+-9.
>
> Does anyone have the solution, please help me.
>
> Thanks a lot.
Received on Wed Dec 15 1999 - 16:05:26 CST