Re: SQL-LOADER and Fixed Point

From: Alan Moor <>
Date: Tue, 24 Aug 1999 21:46:24 -0400
Message-ID: <7pvhub$>

Another alternative:

mynumber position(32:40) decimal external ":mynumber / 10000"

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 Wed Aug 25 1999 - 03:46:24 CEST

Original text of this message