ORACLE 数据导出成文本

spool on
set echo off newpage 0 space 0 pagesize 0 feed off head off
set trimspool on
spool on lines 50
------------------------------------
define file = 'd:/product_stream.txt'--用EXCEL
prompt  ***正在导出***

spool &file

select *  from dual;
spool off
exit