Re: SQL*Loader and Implied decimals

On Mon, 27 Apr 1998 15:35:17 GMT, jybarb01!@homer.louisville.edu (Jay Barbee) wrote:

>Hello all...
>
>I have a flat file that I am trying to import via SQL*Loader. In this
>file there are two fields that contain decimals, but the actual
>decimal is not in the datafile itself.
>
>For example I am importing data that is 3 columns in lenght including
>one decimal place (3,1). So it should look like 12.3, but the file
>has it as 123! How do I tell Loader to expect xxx and turn that into
>xx.x?
>

According to the book (Utility's User Guide) implied decimal points have to be loaded by using a Sqlstring :

NUM_1 position(1:3) decimal external ":NUM_1 / 10"

Greetings

Henk de Wilde Received on Mon Apr 27 1998 - 16:07:25 CDT