sqlldr
hi
I wrote a shell script(bash) for reading the text file and store into database
sample.sh
#!bin/sh
var="test.txt"
path=/sai
sqlldr uname/pwd@dbname control=crl.ctl
crl.ct
Load data infile '/sai/test.txt' into table employee fields terminated by "#" trailing nullcols(Col1,col2,col3)
here in control file i am hardcoding the filename and path name i.e test.txt but i dont want to hard code it.
I need to transfer the filename and pathname stored in variable in shell program(sample.sh) to control file
|