Re: SQL*Loader and Implied decimals

From: <sokol_at_opsb.ru>
Date: Wed, 29 Apr 1998 21:24:21 -0600
Message-ID: <6i8ncl$1qb$1@nnrp1.dejanews.com>

load data

replace

into table YOUR_TABLE
(

YOUR_FIELD integer external (3) ":YOUR_FIELD/10"

)

Luck.

In article <3544a465.1042400602_at_netnews.louisville.edu>, jybarb01!@homer.louisville.edu wrote:
>
> Hello all...
>
> I have a flat file that I am trying to import via SQL*Loader. In this
> file there are two fields that contain decimals, but the actual
> decimal is not in the datafile itself.
>
> For example I am importing data that is 3 columns in lenght including
> one decimal place (3,1). So it should look like 12.3, but the file
> has it as 123! How do I tell Loader to expect xxx and turn that into
> xx.x?
>
> Thanks,
> --Jay
> Jay Barbee
> jybarb01!@homer.louisville.edu
> [ANTISPAM, remove "!" from address above...]
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Apr 29 1998 - 22:24:21 CDT