schema的常用脚本:getcode.sql
添加时间: 2008-4-21 23:48:42 作者: Oracle指导 阅读次数:16 来源: http://www.d9soft.com
set feedback off
set heading off
set termout off
set linesize 1000
set trimspool on
set verify off
spool &1..sql
prompt set define off
select decode( type||'-'||to_char(line,'fm99999'),
'PACKAGE BODY-1', '/'||chr(10),
null) ||
decode(line,1,'create or replace ', '' ) ||
text text
from user_source
where name = upper('&&1')
order by type, line;
prompt /
prompt set define on
spool off
set feedback on
set heading on
set termout on
set linesize 100
上下文章:
上一篇文章: schema的常用脚本:show 下一篇文章: ORACLE性能调优原则