linux环境下把带有|的文本在sqlldr下导入oracle数据库的编程

方法一：

filename=$1
if [ "X${filename}" = "X" ]
then
echo "请输入要导入文件名:"
read filename
fi

#生成loader.ctl文件
rm loader.ctl

echo "load data" >>loader.ctl
echo "infile './${filename}'" >>loader.ctl
echo "replace into table sql" >>loader.ctl
echo "fields terminated by '|'" >>loader.ctl
echo "(groupid,qdyyd)" >>loader.ctl

#导入文件到临时表sql

sqlldr 账号名/密码@数据库库名 control=loader.ctl

方法二：

filename=$1
if [ "X${filename}" = "X" ]
then
echo "请输入要导入号码的文件名:"
read filename
fi

#生成loader.ctl文件
rm loader.ctl

echo "load data" >>loader.ctl
echo "infile './${filename}'" >>loader.ctl
echo "replace into table temp_id" >>loader.ctl
echo "fields terminated by X'0D'" >>loader.ctl
echo "(id)" >>loader.ctl

#导入文件到临时表temp_ljh
sqlldr 账号名/密码@数据库库名 control=loader.ctl