脚本如下
set linesize 200
set term off verify off feedback off pagesize 999
set markup html on entmap ON spool on preformat off
spool file_name.xls
select * from table_name;
spool off
exit
oracle导出文件到excel中
最新推荐文章于 2023-10-12 16:50:40 发布
脚本如下
set linesize 200
set term off verify off feedback off pagesize 999
set markup html on entmap ON spool on preformat off
spool file_name.xls
select * from table_name;
spool off
exit