spool 'c:\temp' select * from scott.emp; spool off;
spool 'd:\文件名.txt' select * from 表名; spool off;
最好先set一下 set line 1000; set pages 0; set trim off; set trimout on; set concat on; set trimspool on; set termout off; set show off; set echo off; set head off; set COLSEP ','; set flush off; set feedback off;
嗯。楼上说的对 至少要设置一下,行长和页长set linesize xxx; set pagesize xxx;spool '\the\path'select xxx xxxx xxx....spool off
select * from scott.emp;
spool off;
select * from 表名;
spool off;
set pages 0;
set trim off;
set trimout on;
set concat on;
set trimspool on;
set termout off;
set show off;
set echo off;
set head off;
set COLSEP ',';
set flush off;
set feedback off;
至少要设置一下,行长和页长set linesize xxx;
set pagesize xxx;spool '\the\path'select xxx xxxx xxx....spool off