SQL*Loader question

From: <shjejurkar_at_yahoo.com>
Date: Tue, 23 Mar 1999 16:19:31 GMT
Message-ID: <7d8eu7$2mi$1@nnrp1.dejanews.com>

Hi,

I am trying to load data from a simple text file (variable length comma separated fields) into a single table. One of the columns in the table is number(8,4). In the text file, there are some rows for which the corresponding field contains number higher that 9999.9999. In such cases, the column should be loaded with zero instead of the number (normally SQL*Loader rejects these rows).

Any suggestions/help on how I can do this will be highly appreciated.

TIA,
Sameer

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Mar 23 1999 - 10:19:31 CST