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