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;
有空可以完善一下实现数据库下的多个表的检测及导出。