sql查询模板

#!/bin/bash
#
source /home/oracle/.bash_profile
    
NOW_DAY=`date +%Y-%m-%d`
date_from=`date +%Y%m%d000000 --date "-1 day"`
date_to=`date +%Y%m%d000000`
run_time=`date +%Y%m%d%H%M%S`
thisweek=`date '+%Y-%m-%d 00:00:00'`
lastweek=`date '+%Y-%m-%d 00:00:00' --date "-7 day"`
thisweek1=`date '+%m%d'`
lastweek1=`date '+%m%d' --date "-7 day"`


HOST_BINDIR="/data/scripts"
HOST_DATADIR="/data/scripts/data"
HOST_LOGDIR="/data/scripts/log"

db_info=$HOST_BINDIR/db.info


time1="$1"
time2="$2"

func_1()
{
    $HOST_BINDIR/ociuldr_linux user=$db_name/$db_passwd@$db_host query="
    select *
    from TableA
    where XXX" field=0x09 record=0x0a file=$HOST_DATADIR/$DATAFILE
}



while read db_name db_passwd db_host
do           

thisdate=`date +%Y%m%d`
DATAFILE=""$thisdate"/"$name"_"

LOGFILE=$DATAFILE".log"

#func writelog
writelog() {
        NOW=$(date +"%Y-%m-%d %H:%M:%S")
        #echo "[$NOW]  $@"  >> $HOST_LOGDIR/$LOGFILE
}

runsql() {

TIME1=`date +%s`
writelog "start execute $_SQL"
#
#
#
func_1
#

TIME2=`date +%s`
TIME_EXPEND=$(($TIME2 - $TIME1))
writelog   "end execute $_SQL"
writelog   "cost $TIME_EXPEND seconds"
}

runsql

done < $db_info