Re: Hex data into SQL*Loader

From: Frans Mazhar <fransmzh_at_unforgettable.com>
Date: 1997/09/11
Message-ID: <3417C24E.3538_at_unforgettable.com>#1/1


John-Paul Mead wrote:
>
> I am trying to load a large database into Oracle 7.3.3. I am planning to
> use SQL*Loader. I have a column of hexadecimal data that I want to load as
> integer data. This column will be used as the primary key, and I believe
> Oracle will more efficiently index the table if it treats this column as
> numerical rather than character data.
> Question: Is there an elegant way to convert the hex to decimal during
> the sqlload? Another option would be to process the datafile first using a
> shell script, and then load it into Oracle.
> Please send help to the email address below.
> --John-Paul Mead
>

Just an idea: Instead of doing it with shell script, you can create a before-insert trigger that change the hexa column into numeric data. Received on Thu Sep 11 1997 - 00:00:00 CEST

Original text of this message