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
扫一扫
8968
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
