多表大数量数据导出

 

set linesize 120

 

set pagesize 0

 

set heading off

 

set term off

 

spool D:\demo20111123.txt

 

select a.item2, b.item3, a.item6 from table1 a

       inner join table2 b on a.item1 = b.item1

       where e.npnf in ('2009','2010') and a.clzt <> 0

;

 

spool off

 

 

上面为导多表多数据的SQL语句脚本