Re: SQL-LOADER fand Fixed Point

ThanX for the hint.

Apropos, you are right. NUMBER(3,5) makes no sense... it is of course NUMBER(8,5)
  Azaria Elburg
In article <01beeade$63db2c60$190114c1_at_sister.grant.UUCP>,   "Alexander I. Doroshko" <aid_at_grant.kharkov.ua> wrote:
> 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
> <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
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Aug 24 1999 - 17:37:55 CEST