或者
sql*plus里面
set pagesize 0;
spool c:\data.txt
select * from tbname;
select * from ..;
...
spool off;
sql*plus里面
set pagesize 0;
spool c:\data.txt
select * from tbname;
select * from ..;
...
spool off;
用pl/sql developer速度好象更快
(FPATH IN STRING,FNAME IN STRING)
is
OutputFile UTL_FILE.FILE_TYPE;
vart_empno emp.empno%TYPE;
vart_ename emp.ename%TYPE;
vart_job emp.job%TYPE;
vart_mgr emp.mgr%TYPE;
vart_hiredate varchar2(10);
vart_sal emp.sal%TYPE;
vart_comm emp.comm%TYPE;
vart_deptno emp.deptno%TYPE;
CURSOR cemp IS
select empno,ename,job,mgr,to_char(hiredate,'yyyy-mm-dd'),sal,comm,deptno
from emp;begin
OutputFile := UTL_FILE.FOPEN(FPATH, FNAME,'W');
--打开
open cemp;
Loop
--游标
fetch cemp into vart_empno,vart_ename,vart_job,vart_mgr,
vart_hiredate,vart_sal,vart_comm,vart_deptno;
--输入
UTL_FILE.PUTF(OutputFile, '"%s";', vart_empno);
UTL_FILE.PUTF(OutputFile, '"%s";', vart_ename);
UTL_FILE.PUTF(OutputFile, '"%s";', vart_job);
UTL_FILE.PUTF(OutputFile, '"%s";', vart_mgr);
UTL_FILE.PUTF(OutputFile, '"%s";', vart_hiredate);
UTL_FILE.PUTF(OutputFile, '"%s";', vart_sal);
UTL_FILE.PUTF(OutputFile, '"%s";', vart_comm);
UTL_FILE.PUTF(OutputFile, '"%s"\n', vart_deptno);
--
UTL_FILE.FFLUSH(OutputFile);
--退出
exit when cemp%NOTFOUND;
End Loop;
--关闭
close cemp;
UTL_FILE.fclose(OutputFile);
end output_data_txt;