这是itpub上看到 摘录下来 下次自己也可以用到 呵呵:
http://www.itpub.net/thread-999031-1-1.html
http://www.eygle.com/archives/2005/04/eoasqlplusieaae.html
http://www.itpub.net/361288.html
相关这方面的文章
sqlplus 能生产xls的excel文件
connect / as sysdba;
SET NEWPAGE 0
SET SPACE 0
SET LINESIZE 80
SET PAGESIZE 0
SET ECHO OFF
SET FEEDBACK OFF
SET VERIFY OFF
SET HEADING OFF
SET MARKUP HTML OFF SPOOL OFF
set markup html on;
spool c:abc.xls
select * from tab;
spool off;