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
You can find the utilities guide that includes sqlldr thru this url http://tahiti.oracle.com Received on Mon Jan 15 2007 - 16:32:08 CST