用sql脚本做spool set feedback off; set header off; set term off; set colsep ",";spool filename1; select * from table1; spool off;spool filename2; select * from table2; spool off;spool filename3; select * from table3; spool off;spool filename4; select * from table4; spool off;保持成一个sql文件SQL>@脚本的路径
用sql脚本做spool
set feedback off;
set header off;
set term off;
set colsep ",";spool filename1;
select * from table1;
spool off;spool filename2;
select * from table2;
spool off;spool filename3;
select * from table3;
spool off;spool filename4;
select * from table4;
spool off;保持成一个sql文件SQL>@脚本的路径
http://blog.csdn.net/suncrafted/archive/2009/07/06/4324633.aspx