shell批量添加Oracle字段,学习随笔（一）：Shell脚本批量导入数据到Oracle数据库...

#!/bin/sh

#

# @test.sh

# @文件数据导入oracle

# @version 1.0

TABLE="T_RECO"

if [ $# -ne 1 ]; then

echo $0 DATAFILE

echo

exit 2

fi

data=$1

while read line;

do

query=`echo $line | awk 'BEGIN{FS="\03"}{

printf("'\''%s'\'','\''%s'\'','\''%s'\'','\''", $1, $2, $3);

if ($4 == "1") {

printf("123456\&'\''\|\|'\''我最伟大\&'\''\|\|'\''%s\|",$9)

};

if ($5 == "1") {

printf("234567\&'\''\|\|'\''我最渺小\&'\''\|\|'\''%s\|",$10)

};

if ($6 == "1") {

printf("345678\&'\''\|\|'\''我最厉害\&'\''\|\|'\''%s\|",$11)

};

if ($7 == "1") {

printf("456789\&'\''\|\|'\''我最牛逼\&'\''\|\|'\''%s\|",$12)

};

if ($8 == "1") {

printf("567890\&'\''\|\|'\''我最无语\&'\''\|\|'\''%s\|",$13)

};

printf("'\'','\''%s'\'','\''%s'\'','\''%s'\''", $14, $15, $16)}'`

statement=`echo "INSERT INTO $TABLE(MONTH,CODE,ID,INFO,R_ID,TUDE,ITUDE) VALUES($query);"`

echo $statement >>sql.txt

done < $data

sqlplus test/test@XX.XX.XX.XX:1521/db<

@sql.txt

commit;

exit

EOF

if [[ $? -eq 0 ]]; then

echo "Wrote data into DB"

fi