在linux中拉取数据库的数据

su - -c "sqlplus \"${DB_USERNAME}/${DB_PASSWORD}@//${DB_IP}:${DB_PORT}/${DB_INSTANCE_NAME}\" \"@${program_dir}/CollectionLog.sql\"" oracle

 

 

spool on

set echo off;

set heading off;

set linesize 1000;

set long 1000;

set pagesize 0;

set colsep '|' ;

set sqlblanklines off;

set termout off;

set trimspool on;

set termspool off;

set term off;

set newpage 1;

set feedback off;

spool /home/Log_20131225_14:35:58-20131228_15:09:51_Auto.txt

select t.log_id||'|'||t.module_id||'|'||t.operater||'|'||t.operater_ip||'|'||t.operate_time||'|'||t.operate_content||'|'||t.operate_result from t_log_operate_info t where t.operate_time between '2013-12-25 14:35:58' and '2013-12-28 15:09:51' ;

spool off

exit