SET echo off SET feedback off SET pagesize 50000 SET linesize 20000 SET verify off SET pagesize 0 SET term off SET trims ON SET heading off SET trimspool ON SET trimout ON SET timing off SET verify off SET colsep " spool d:\cust_brand.txt SELECT * FROM CUST_BRAND; spool off
将以上存储过程,保存在SQL中,然后在PLSQL的命令行模式下执行就可以了,SQL> @d:\export_test.sql;
有空可以完善一下实现数据库下的多个表的检测及导出。