导出数据库表中数据

#昨天是导入,今天是导出,但是感觉好像缺点什么....

#!/bin/sh
tab=$1
path="$2"

if [ "X$tab" = "X" ]
then
    echo "Usage: `basename $0` tablename "
    exit
fi

if [ "X$path" = "X" ]
then
    file=$tab
else
    file=$path
fi

sqlplus -S /nolog >/dev/null <<!
conn $INIT_USING_DBASE/$INIT_USING_DBASEPWD
SET HEADING OFF
SET FEEDBACK OFF
SET PAGESIZE 0
SET FLUSH OFF
SET LINES 1000
SET TRIMOUT ON
SET TRIMSPOOL ON
spool ${tab}_$$.tmp

SELECT * FROM $tab;  
spool off
!
awk '{c=1
        while(c<=NF)
        {
            printf("%s|",$c)
            c++
        }
        printf("\n")
    }'  ${tab}_$$.tmp > $file.cfg

rm -f ${tab}_$$.tmp