日期:2014-05-17 浏览次数:20920 次
sqlplus 'd_zctt/d_zctt$zj1106@zjshdb' <<EOF
set echo off;
set feedback off;
set heading off;
set verify off;
set termout off;
set pagesize 0;
spool on;
spool /opt/zjdata/data.dat;
select * from table_name partition(P_20110723) where first_result>=to_date('2011-07-23 00:00:00','YYYY-MM-DD HH24:MI:SS')
and first_result<=to_date('2011-07-23 00:05:00','YYYY-MM-DD HH24:MI:SS');
spool off;
EOF
exit