Re: Sql-Loader

I have been successful in loading negative numbers with sqlloader. However, my script looks like your script except that the negative sign goes in front of the number.

For example, table temp has a column 'COL1' defined as a number(10,2).

My control file looks like:

load data
into table temp

        (col1 position (01:10) decimal external,
         col4 position (31:41) date)

The datafile looks like:                         

-1111111111-DEC-92
  44.444412-AUG-92 Jan Griffin, DBA
Solbourne Computers
303-678-4331 Received on Wed Sep 30 1992 - 19:33:19 CET