导出数据批处理－－oracle

set echo off
set feedback off
set newpage none
set verify off
set pagesize 0
set term off
set trims on
set linesize 600
set heading off
set timing off
set numwidth 38
SPOOL D:\segment_data.txt
select AREA_CODE||'_'||OPERATE_BELONG||','||SERV_SEGMENT FROM ZHT_SEGMENT_NEW2 WHERE rownum<=1000000;
SPOOL OFF