使用spol导出exce

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;

 

此文转载而来,原址找不到了

 

posted @ 2016-03-29 14:37  式微胡不归  阅读(212)  评论(0编辑  收藏  举报