set echo on
set feedback off
set heading off
set trimspool off
set pagesize 1000
set linesize 50
set term off
define file= '/usr/tmp/src/expfile.txt'
prompt *** Spooling to &file
spool &file
select A11001||','||A11002||','||A11003 from A11;
spool off;
把sql查询结果输出到文件
最新推荐文章于 2024-04-25 14:35:04 发布