Re: SQL-LOADER fand Fixed Point

From: Victor Krokhmal <>
Date: Sun, 22 Aug 1999 14:00:25 +0300
Message-ID: <>

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
> Share what you know. Learn what you don't.
Received on Sun Aug 22 1999 - 13:00:25 CEST

Original text of this message