Re: sql*loader

go to oracle home directory
then go to sql loader sample directory you will get some example that will help you

joe_lopez_at_my-dejanews.com wrote in article <7ed7r9$un$1_at_nnrp1.dejanews.com>...
> 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 Own
 

>
Received on Wed Apr 07 1999 - 16:50:40 CEST