SQL*Loader question
From: <shjejurkar_at_yahoo.com>
Date: Mon, 22 Mar 1999 20:01:58 GMT
Message-ID: <7d67jh$5t4$1_at_nnrp1.dejanews.com>
Hi,
Date: Mon, 22 Mar 1999 20:01:58 GMT
Message-ID: <7d67jh$5t4$1_at_nnrp1.dejanews.com>
Hi,
I am trying to load data from a simple text file (variable length data with fields comma separated) into a table.
[Quoted] If the value (number) in one of the fields is more than 9999.9999, the corresponding column should be loaded with 0 (zero) instead of the original number in the field.
Can anyone tell me how I can do this?
TIA,
Sameer
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Mar 22 1999 - 21:01:58 CET