sql*loader documentation?
From: <joe_lopez_at_my-dejanews.com>
Date: Tue, 06 Apr 1999 14:46:03 GMT
Message-ID: <7ed6n9$vv8$1_at_nnrp1.dejanews.com>
I am looking for basic instructions on using the sql*loader utility for oracle 7.3. Specifically I'm looking for a way to set up a simple control file that will insert constant field information into a table.
)
Date: Tue, 06 Apr 1999 14:46:03 GMT
Message-ID: <7ed6n9$vv8$1_at_nnrp1.dejanews.com>
I am looking for basic instructions on using the sql*loader utility for oracle 7.3. Specifically I'm looking for a way to set up a simple control file that will insert constant field information into a table.
my control file looks like this:
OPTIONS(ERRORS=1000, DIRECT=TRUE)
LOAD DATA
INFILE "data/filename.txt"
REPLACE
INTO TABLE LI_GEO_LOAD
TRAILING NULLCOLS
(field1 POSITION(1:20) INTEGER EXTERNAL, field2 POSITION(21:30) char, [Quoted] /*I want to override the data for this field 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 Own Received on Tue Apr 06 1999 - 16:46:03 CEST