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

Home -> Community -> Usenet -> c.d.o.misc -> passing environment variable into SQL Loader on Unix for Oracle 8.0.5

passing environment variable into SQL Loader on Unix for Oracle 8.0.5

From: Me <annardo_at_earthlink.net>
Date: Thu, 21 Oct 1999 10:56:30 -0400
Message-ID: <7un99h$k0t$1@holly.prod.itd.earthlink.net>


Is it possible to pass an environment variable into SQL Loader on Unix for Oracle 8.0.5?

e.g.
in the control file I have a line that looks like column1 constant 500

I would like to be able to pass other numeric values in place of 500. These values will be set from within a shell script.

TIA Received on Thu Oct 21 1999 - 09:56:30 CDT

Original text of this message

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