Re: SQL-LOADER and Fixed Point
From: Alan Moor <asmoor_at_ix.netcom.com>
Date: Tue, 24 Aug 1999 21:46:24 -0400
Message-ID: <7pvhub$t7l_at_dfw-ixnews13.ix.netcom.com>
Date: Tue, 24 Aug 1999 21:46:24 -0400
Message-ID: <7pvhub$t7l_at_dfw-ixnews13.ix.netcom.com>
Another alternative:
mynumber position(32:40) decimal external ":mynumber / 10000"
Azaria Elburg wrote in message <7ph68h$vdj$1_at_nnrp1.deja.com>...
>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 Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Wed Aug 25 1999 - 03:46:24 CEST