cat insertpermin.sh
#!/bin/sh
# inserttoday
#conf file
CONF=/home/oracle/conf/conf.sh
. ${CONF}
source /home/oracle/.bash_profile
tdate=`date +'%Y%m%d'`
echo ${tdate}>>${LOGFILE}
ttime=`date`
echo ${ttime}>>${LOGFILE}
while read LINE; do
LINE1=`echo ${LINE} | cut -d , -f 1`
LINE2=`echo ${LINE} | cut -d , -f 2`
LINE3=`echo ${LINE} | cut -d , -f 3`
LINE4=`echo ${LINE} | cut -d , -f 4`
LINE5=`echo ${LINE} | cut -d , -f 5`
LINE6=`echo ${LINE} | cut -d , -f 6`
LINE7=`echo ${LINE} | cut -d , -f 7`
LINE8=`echo ${LINE} | cut -d , -f 8`
LINE9=`echo ${LINE} | cut -d , -f 9`
LINE10=`echo ${LINE} | cut -d , -f 10`
LINE11=`echo ${LINE} | cut -d , -f 11`
echo "${LINE1} ${LINE2} ${LINE3} ${LINE4} ${LINE5} ${LINE6} ${LINE7} ${LINE8} ${LINE9} ${LINE10} ${LINE11}">>${LOGFILE}
sqlplus fx/fx @/home/oracle/job/insertpermin.sql ${LINE1} ${LINE2} ${LINE3} ${LINE4} ${LINE5} ${LINE6} ${LINE7} ${LINE8} ${LINE9} ${LINE10} ${LINE11}
done < "/home/oracle/csv/${tdate}_min.csv";
# After executing insert sql
cat "/home/oracle/job/SPOOL_permin.txt">>${LOGFILE}
mv "/home/oracle/csv/${tdate}_min.csv" "/home/oracle/csv/${tdate}_min_end${LINE3}.csv"
echo "/home/oracle/csv/${tdate}_min.csv /home/oracle/csv/${tdate}_min_end${LINE3}.csv">>${LOGFILE}
rm /home/oracle/job/SPOOL_permin.txt
echo "RM /home/oracle/job/SPOOL_permin.txt">>${LOGFILE}
echo ""
echo "FIN">>${LOGFILE}
cat insertpermin.sql
spool "/home/oracle/job/SPOOL_permin.txt"
INSERT INTO FX_MIN (ID,F_DATE,F_TIME,START_VALUE,HIGH_VALUE,LOW_VALUE,END_VALUE,START_VALUE_DIFF,HIGH_VALUE_DIFF,LOW_VALUE_DIFF,END_VALUE_DIFF) VALUES ('&1','&2','&3','&4','&5','&6','&7','&8','&9','&10','&11');
spool off
exit;