一个生成CTL文件的SHELL

#! /usr/bin/sh

cat filelist | while read line
do
        TableName=$line
        echo $TableName

        sqlstr="desc $TableName;"

        # a sql statement

        echo "set linesize 50">tmp.sql
        echo "spool "$TableName"_column.txt">>tmp.sql
        echo $sqlstr >>tmp.sql
        echo "quit;">>tmp.sql

        # execute the sql
        sqlplusUSER/PASSWORD@NETNAME  @tmp.sql >/dev/null

        awk '{if(NR!=1 && NR!=2) print $1}' $TableName'_column.txt' >1.txt
        sed '/^$/d' 1.txt > $TableName'_column.txt'

        ColName=''

        cat $TableName'_column.txt' | while read LINE
        do
                        ColName=$ColName$LINE','
        done

        echo "LOAD DATA\nINTO TABLE $TableName\nappend\nfields terminated by \"|#|#|\"\n(" > $TableName.ctl
        echo $ColName | sed 's/,$//' | awk -F, '{for(i=1;i<NF;i++) printf "%s,\n",$i } {print $NF}' >> $TableName.ctl
        echo ")" >> $TableName.ctl

done

-----------------------------------------

补充说明:filelist是一个文件,里面存放的是要生成ctl文件的表名,格式如下:

come_account

go_account