connect database example with sqlplus

sql文件:

set echo off;
set feedback off;
set heading off;
set linesize 300;
set newpage none;

select to_char(SEND_DATE, 'yyyy-mm-dd') as SEND_DATE, count(INQ_ID) as total from abc where TRUNC(SEND_DATE)>TRUNC(sysdate-3) and TRUNC(SEND_DATE)<=TRUNC(sysdate) group by (SEND_DATE) order by 1;

quit

命令：only for oracle database.

sqlplus -s $userpwd@$sid @$SQL_SCRIPT_HOME/export_inquire_increase.sql >> $newFileName;