is there any way to pass the UNIX variable to SQL *Loader.

is there any way to pass the UNIX variable to SQL *Loader.

 

  

Hi all,



I've created one shell script it's called the sql loader for load the
flat file into DB table. The flat file has been created by UNIX shell
script.

I wanted to pass the UNIX current directory to the sql loader (I have
assigned the current DIR into one variable) so I want to pass the
variable to sql loader. How can I do it...?







Thanks and regards,

Siva.P

Bangalore




Oracle LazyDBA home page