利用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