Re: SQL*LOAD
From: Peter Kane <pkane_at_cisco.com>
Date: 23 May 1994 19:24:54 GMT
Message-ID: <2rqvu6$3c2_at_cronkite.cisco.com>
Date: 23 May 1994 19:24:54 GMT
Message-ID: <2rqvu6$3c2_at_cronkite.cisco.com>
In article <19940520.132446.284_at_almaden.ibm.com> smith_at_VNET.IBM.COM writes:
>I am loading an input file that contains a field with an implied decimal
>point (ie value 22 represents 2.2). Can this field be formatted with an
>explicit decimal point by SQL*LOAD by specifying a certain datatype and
>format?
In your control file (.ctl) you could specify the following, where the field name is "fname" in this case:
fname ":fname/10"
This will divide the field "fname" by 10 as it loads it into the database.
Peter
pkane_at_cisco.com
Received on Mon May 23 1994 - 21:24:54 CEST