Re: SQL-LOADER fand Fixed Point

From: Alexander I. Doroshko <aid_at_grant.kharkov.ua>
Date: 20 Aug 1999 07:37:18 GMT
Message-ID: <01beeade$63db2c60$190114c1_at_sister.grant.UUCP>


The corresponding line in your ctl file must be as

my_field char(8) ":my_field/100000"

A propos, isn't the format NUMBER(3, 5) erroneous? You can't put 123.45678 into such a field. Azaria Elburg <azaria_at_my-deja.com> wrote in article [Quoted] <7ph5n3$uul$1_at_nnrp1.deja.com>...
: 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
Received on Fri Aug 20 1999 - 09:37:18 CEST

Original text of this message