SQL-LOADER and Fixed Point

From: Azaria Elburg <azaria_at_my-deja.com>
Date: Thu, 19 Aug 1999 15:01:46 GMT
Message-ID: <7ph68h$vdj$1_at_nnrp1.deja.com>

[Quoted] [Quoted] I am trying to load into a field defined as NUMBER (8,5) . [Quoted] 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 Thu Aug 19 1999 - 17:01:46 CEST

Original text of this message