spool 用手写的脚步和sql语句导出文件小,直接copy,edit就可以用
cmd->sqlplus /nolog->@脚步绝对路径
脚本:
conn user/pwd@db
SET HEADING OFF
SET ECHO OFF
SET FEEDBACK OFF
SET PAGES 0
SET LINESIZE 2000
SET LONG 500
SET TRIMOUT ON
SET TRIMSPOOL ON
SET NEWPAGE NONE
SET SQLBLANKLINES OFF
SET TRIMS ON
SET TIMING OFF
SET SERVEROUTPUT ON
SET VERIFY OFF
SET trimspool on
spool e:/hchx/datawork_order_list.csv;
--加中文表头
select '账册号,工单号,领料日期,料号,数量,创建日期' from dual union all
select EMS_NO ||','|| wo_no ||','|| to_char(take_date,'YYYY-MM-DD') ||','|| COP_G_NO ||','|| QTY||','|| to_char(CREATE_DATE,'YYYY-MM-DD') from
work_order_list t where t.ems_no='H46121000002' and t.create_date >= to_date('2012-05-01','yyyy-mm-dd')
and t.create_date <=to_date('2012-06-30','yyyy-mm-dd');
spool off;