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

Post by Me » Sun, 31 Dec 1899 09:00:00



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