本文展示了如何使用SQL查询结合输出CSV文件的过程，包括设置SQL提示、输出样式及查询语句的实现。
set echo off
set feedback off
set linesize 1000
set pagesize 0
set sqlprompt ''
set trimspool on
spool D:\\emp_sal.csv
select '"employee_id","last_name","first_name","salary"' from dual union all select empno || ',"' || ename || '","' || ename || '",'|| sal from emp;
spool off
exit
set feedback off
set linesize 1000
set pagesize 0
set sqlprompt ''
set trimspool on
spool D:\\emp_sal.csv
select '"employee_id","last_name","first_name","salary"' from dual union all select empno || ',"' || ename || '","' || ename || '",'|| sal from emp;
spool off
exit
扫一扫
2809
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
