Hex data into SQL*Loader

  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

+------------------------------------------------------------------+


| John-Paul D. Mead                         home :  (718) 596-2357 |

| Class of 1998                             beep :  (917) 953-5777 |

| NYU School of Medicine                    work :  (212) 263-5744 |

|                                                                  |

| mailto:meadj01_at_popmail.med.nyu.edu                               |

| http://shamrock.med.nyu.edu/~meadj01                             |

|                                                                  |

| PGP Key at: http://shamrock.med.nyu.edu/~meadj01/pgp.html        |


+------------------------------------------------------------------+