schema的常用脚本:gettrig.sql
添加时间: 2008-4-26 1:46:53 作者: Oracle指导 阅读次数:27 来源: http://www.d9soft.com
gettrig.sql --获得触发器脚本
set heading off
set feedback off
set linesize 1000
set trimspool on
set verify off
set termout off
set embedded on
spool &1..sql
select
'create or replace trigger "'||
trigger_name||'"'||chr(10)||
decode(substr(trigger_type,1,1),
'A','AFTER','B',BEFORE','I','INSTEAD OF')||
CHR(10)||
triggering_event||chr(10)||
'ON"'||table_owner||'"."'||
table_name||'"'||chr(10)||
decode(instr(trigger_type,'EACH ROW'),0,null,
'FOR EACH ROW')||chr(10),
trigger_body
from user_triggers
where trigger_name = upper('&1')
/
prompt /
spool off
set verify on
set feedback on
set termout on
set heading on
上一篇文章: schema的常用脚本:getallview.sql 下一篇文章: OracleSQL内置函数大全之一
相关软件: