SQLLoader and implied decimals
From: Brian Lawler <brian.lawler_at_mci.com>
Date: 1997/08/01
Message-ID: <33E2454E.3A21_at_mci.com>#1/1
Date: 1997/08/01
Message-ID: <33E2454E.3A21_at_mci.com>#1/1
Please help.
How can I use SQLLoader to read a text file with an implied decimal.
E.g
Company ABC 12345
Company XYZ 8999
My Company 34555
In this example, the text "12345" is intended to be interpreted as
$123.45.
I can control the target table and use and field/column type I want in
the target table if that helps.
I've tried using DECIMAL EXTERNAL, DECIMAL, etc. in the SQLLoader
control file but no luck yet. E.g.:
load data into my_table ( company_name position(1:11) char, amount position(15:19) decimal )Received on Fri Aug 01 1997 - 00:00:00 CEST