使用spool 批量导出和导入

#!/bin/ksh
. ${HOME}/.profile

sysBinPath="/usr/bin"
filePath="/root/work/xyz/shell/bill_update/file"
shellPath="/root/work/xyz/shell/bill_update"
logPath="/root/work/xyz/shell/bill_update"


#生成导入数据到文件
getIdInfo()
{
        sqlplus user/pwd@db<<!
        set feedback off;
        set head off;
        set colsep '|';
        spool ${1};
        select to_char(trim(id_no)),'Y','0','0',0,'0', 'YXQQ' 
                        from table where condition
        spool off;
        exit;
!
}

dateStr=`date +%Y%m`
tmpFileName="${filePath}/139MailUserList${dateStr}.tmp";

#生成文件
getIdInfo $tmpFileName

#处理生成文件头尾 (！！！TODO: 这里的６是在函数getIdInfo中的语句条目数)
sed -e '1,6d' ${tmpFileName} > ${tmpFileName}_1

fileName="${filePath}/139MailUserList${dateStr}.txt"
sed -e '$d' ${tmpFileNa