spool数据导出

column dat1 new_value filename;

set echo off;

set verify off;

set feedback off;

set heading off;

set termout off;

set trimout on;

set trimspool on;

set wrap off;

set pagesize 0;

set linesize 9999;

set timing OFF;

set colsep chr(9);

SPOOL path

select *from yourtable

SPOOL OFF;