吾生有涯,而知无涯,适当止学.循序渐进,步步提升 Talk is cheap, show me the code.
分类: Oracle
2012-12-25 15:11:59
set trimspool on
set linesize 20000
set pagesize 0
set newpage 1
set heading off
set term off
spool 路径+文件名
select col1 ||'|'|| col2 ||'|'|| col3 ||'|'|| col4 from tablename;
spool off