通过sql*plus输出excel、html格式文件

 

rem #################################################
rem 通过sql*plus输出xls，html格式文件
rem 2005-08-04 Created by xsb
rem #################################################

sqlplus /nolog @tohtml.sql

set linesize 100
set trimspool on
set term off verify off feedback off pagesize 999
set markup html on entmap ON spool on preformat off
conn
spool tohtml.xls
select * from scott.emp;
spool off
exit