可以实现的,用下面的语句: SET echo off SET feedback off SET newpage none 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:\table1.txt select 字段1 ||'%'||字段2 ||'%'||字段3 ||'%'||字段4 from table a ; spool off
http://wenku.baidu.com/view/aa2c0f69561252d380eb6ecd.html
SET echo off
SET feedback off
SET newpage none
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:\table1.txt
select
字段1
||'%'||字段2
||'%'||字段3
||'%'||字段4
from table a ;
spool off
或者CSV文件。