Re: SQL-LOADER and Fixed Point

From: Cheryl Dopp <>
Date: Fri, 20 Aug 1999 08:39:05 -0600
Message-ID: <OJf37mx6#GA.242_at_cpmsnbbsa03>

You'll have to do something like this:
to_number(substr(NUM, 0, 3) || '.' || substr(NUM, 3, (len(NUM) -3))

to concatenate the decimal point in there. Note that substr may not need the third argument for the rest of the number (in the second substr expression, and you may have to make some small adjustments in the arguments (it may actually be 2 rather than 3 in the second substr expression). But this should get you started.

Azaria Elburg wrote in message <7ph68h$vdj$>...
>I am trying to load into a field defined as NUMBER (8,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 Fri Aug 20 1999 - 16:39:05 CEST

Original text of this message