Reviews
how to use STR infile directive with command-line 'DATA=' parameter ? April 30, 2002 - 8am US/Eastern Bookmark | Bottom | TopReviewer: Paul Ryan from London
Thanks for this very useful summary of the options available for using SQL*Loader when there are
newlines in the data to be loaded.
Of course using the STR attribute on the infile directive is the best way - but, how do you use
this technique if you are specifying the datafile name on the command line (and so there is no
INFILE directive in the control file) ?
Followup April 30, 2002 - 11am US/Eastern:
data= on the command line will always override the infile= in the ctl file, so just
load data
infile to_be_named.later "str X'7c0a'"
into table T
TRUNCATE
and use data= on the command line
Partager