shell中 sql

方法一：

#!/usr/bin/ksh

tdbyd_1=$(date -d"`date +%y%m01` last day" +%Y%m%d160000)
tdbyd_2=$(date -d"`date -d -1month +%y%m01` last day" +%Y%m%d160000)

 

sql_mod="set line 300\n set head off\n set feed off\n set pagesize 0\n set colsep \"|\" \n alter session set nls_date_format='yyyymmddhh24miss'; \n"
>1234.txt

echo "channel_id|be_id|status|sum(payment)|count(1)">>1234.txt

cat link3.cfg|grep "ardb"|awk -F "|" '{print $2,$3}'|while read conn_str pdbuser
do

      sql_str="select t.channel_id,t.be_id,t.status,sum(t.payment_amt),count(1)  from ${pdbuser}.ar_payment t  where t.CHANNEL_ID  in ( '11','5') and (t.payment_date+1/3)>to_date('${tdbyd_2}','YYYYMMDDHH24MISS') and (t.payment_date+1/3)<=to_date('${tdbyd_1}',