Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Referencing parameter value within a SQLLDR control file
barraboombarrabin wrote:
> Hi,
> I have sqlldr script whose control file looks like this -
>
>
> INSERT NTO TABLE TEST
> FIELDS TERMINATED BY '|'
> (
> COL1,
> COL2,
> COL3 "<data filename>"
> )
>
>
> The value in COL3 is a constant and it should be the data file name
> that I have passed the sqlldr utility using the "data" parameter. My
> question is how can I reference the value of the data parameter within
> the sqlldr control file.
>
> Any suggestions would be appreciated.
>
> thanks
use vi and type it in.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Mon Jan 15 2007 - 19:07:13 CST