Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Referencing parameter value within a SQLLDR control file

Re: Referencing parameter value within a SQLLDR control file

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 15 Jan 2007 14:32:08 -0800
Message-ID: <1168900328.248901.47390@51g2000cwl.googlegroups.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US