源地址：http://wallimn.iteye.com/blog/472182
set trimspool on
set linesize 120
set pagesize 2000
set newpage 1
set heading off
set term off
spool 路径+文件名
select col1||‘,‘||col2||‘,‘||col3||‘,‘||col4||‘..‘ from tablename;
spool off
原文：http://www.cnblogs.com/haizine/p/5843294.html