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: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 15 Jan 2007 17:07:13 -0800
Message-ID: <1168909631.11313@bubbleator.drizzle.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

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.org
Received on Mon Jan 15 2007 - 19:07:13 CST

Original text of this message

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