Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SQLLOADER

SQLLOADER

From: GERNEZ <fgernez_at_partner.auchan.com>
Date: Wed, 15 Dec 1999 10:16:52 +0100
Message-ID: <837m26$c7j$1@news.imaginet.fr>


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 - 03:16:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US