Sqlldr
hi
I wrote a shell script(bash) for reading the text file and store into database
sample.sh
#!bin/sh
var="test.txt"
sqlldr uname/pwd@dbname control=crl.ctl
Load data infile '/sai/test.txt' into table employee fields terminated by "#" trailing nullcols(Col1,col2,col3)
But her the Delimiter can be anything(like # r |) so delimiter i m storing in variable
I created the control.template is mentioned below
Load data infile '/REPLACE_ME/' into table employee fields terminated by "#" trailing nullcols(Col1,col2,col
For REPLACE_ME
sed "s@REPLACE_ME@$input@" control.template > crlfilename.ctl
its going to replace path/file name
is dere anything like this 4 delimiter
I m posoting it again because i have not given more details in my previous thread I 4got the thread title to modify
|