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