Re: SQL-LOADER fand Fixed Point

From: Victor Krokhmal <gbkit_at_moc.kw>
Date: Sun, 22 Aug 1999 14:00:25 +0300
Message-ID: <37BFD849.9A8BB002_at_moc.kw>


You can use the following formula in the control file:

...
nfield "TO_NUMBER(:nfield/100000)"
...

i.e. divide an original value by 10^(decimals).

Azaria Elburg wrote:

> I am trying to load into a field defined as NUMBER (3,5) .
> The problem is that in the data file there is no decimal point. For
> example the field in the file will contain "12345678".
> I want this to be loaded so that the field will contain 123.45678
> How can I do this?
>
> ThanX in advance,
> Azaria Elburg
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Sun Aug 22 1999 - 13:00:25 CEST

Original text of this message