本文介绍了一个使用PL/SQL将数据库查询结果导出到Excel文件的示例。通过设置输出格式并利用spool命令，演示了如何将员工信息以特定格式输出到Excel文件中。此方法适用于需要定期生成报表的应用场景。
SET LINESIZE 2000
SET TERM OFF VERIFY OFF FEEDBACK OFF PAGESIZE 9999
SET MARKUP HTML ON ENTMAP ON SPOOL ON PREFORMAT OFF
spool emp.xlsx
select '"employee_id","last_name","first_name","salary"' from dual union all select empno || ',"' || ename || '","' || ename || '",'|| sal from emp;
SPOOL OFF
EXIT
SET TERM OFF VERIFY OFF FEEDBACK OFF PAGESIZE 9999
SET MARKUP HTML ON ENTMAP ON SPOOL ON PREFORMAT OFF
spool emp.xlsx
select '"employee_id","last_name","first_name","salary"' from dual union all select empno || ',"' || ename || '","' || ename || '",'|| sal from emp;
SPOOL OFF
EXIT
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
