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

Home -> Community -> Usenet -> c.d.o.server -> Re: Direct path sqlldr and implied decimals problem

Re: Direct path sqlldr and implied decimals problem

From: BobH <b-horton_at_worldnet.att.net>
Date: Thu, 04 Jun 1998 21:48:58 -0400
Message-ID: <6l7irh$rj4@bgtnsc02.worldnet.att.net>


Paul McGettigan wrote:
>
> I am having a problem reading in implied decimals using direct path sqlldr
>
> I have numeric data coming accross in the format
> 1234567890-
> 0000012345+
> 0000002222-
>
> I have tried to read the data in using the zoned decimal format and while it
> successfully adds the rows it is ignoring the signs.
> All rows are loaded as positive numbers.
>
> The fields in the table have been declared as
>
> test_amt number(10,2)
>
> The sqlldr control file is reading the data as
>
> test_amt position(1:11) zoned(10,2)
>
> Using the conventional path sqlldr is possible I know - but due to the size of
> the datafiles (1GB) is impractical.
>
> Has anyone got any suggestions?
>
> Thanks
> Paul

Since numeric data can have trailing or leading signs you might give sqlldr and hint where the sign is. If there is no negative numbers in your data you can ignore the sign.

luck. Received on Thu Jun 04 1998 - 20:48:58 CDT

Original text of this message

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