利用spool,输出代码,csv文件等。
set trimspool on
set linesize 20000
set pagesize 0
set echo off
set feedback off
set newpage 1
set heading off
set wrap off SQLBLANKLINES OFF
set term off
spool C:\TEST\TEST.sql
select text from user_source where name = 'TEST' AND type='PACKAGE' order by name, line;
spool off