sql*loader
From: <joe_lopez_at_my-dejanews.com>
Date: Tue, 06 Apr 1999 15:05:17 GMT
Message-ID: <7ed7r9$un$1_at_nnrp1.dejanews.com>
[Quoted] I looking for documentation or help for using sql*loader. I would like to substitute constant data for some of the data in my flat file as I load to the oracle tables. Ex:
OPTIONS(ERRORS=1000, DIRECT=TRUE)
LOAD DATA
INFILE "data/filename.txt"
REPLACE
INTO TABLE TEST
TRAILING NULLCOLS
Date: Tue, 06 Apr 1999 15:05:17 GMT
Message-ID: <7ed7r9$un$1_at_nnrp1.dejanews.com>
[Quoted] I looking for documentation or help for using sql*loader. I would like to substitute constant data for some of the data in my flat file as I load to the oracle tables. Ex:
OPTIONS(ERRORS=1000, DIRECT=TRUE)
LOAD DATA
INFILE "data/filename.txt"
REPLACE
INTO TABLE TEST
TRAILING NULLCOLS
(FIELD1 POSITION(1:20) INTEGER EXTERNAL, FIELD2 POSITION(21:30) char, /*THIS IS WHERE I WANT TO OVERRIDE MY DATA AND INSERT A QUOTED STRING*/ FIELD3 POSITION(31:40) char) -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your OwnReceived on Tue Apr 06 1999 - 17:05:17 CEST