sqlldr控制文件fileds带有变量

Question

infile ‘c:sandeep.txt’
truncate
into table emp
fields TERMINATED BY “|”
trailing nullcols(
column_name constant “${variable}”,
)

sqlldr由shell脚本运行，是否有任何方法将变量传递给sqlldr并使字段使用我传递给它的内容？

Answer 1

这个怎么样：

#!/bin/sh
#-- setup
col_name=MY_COL_NAME
#-- create the control file.  Have to escape the double-quotes
rm myloader.ctl      2>/dev/null
echo infile ‘c:sandeep.txt’                >> myloader.ctl
echo truncate                              >> myloader.ctl
echo into table emp                        >> myloader.ctl
echo fields TERMINATED BY "|"            >> myloader.ctl
echo "trailing nullcols("                  >> myloader.ctl
echo column_name constant "${col_name}", >> myloader.ctl
echo ")"                                   >> myloader.ctl
#
#-- check the results
cat myloader.ctl
#-- run sqlldr
sqlldr control=myloader.ctl