应用:将操作结果导入到文件中

利用sqlplus的命令spool完成:

sql 代码

set feedback off
set pages 0
set linesize 544
set TRIMOUT on
set trimspool off
set ver off
set heading off
set time off
set timing off
set autot off
set echo off
set show off
set term off

spool &1
select * from report_user;
spool off
set feedback 6
set pages 100
set lines 100
set heading on
set echo on
set show on
set term on
set TRIMOUT on
set trimspool on