Re: Trigger Script Generation

From: Константин Лаценюк <kwl_at_cbsd.donetsk.ua>
Date: Tue, 18 Jan 2000 15:40:17 +0200
Message-ID: <38846D41.B299A854@cbsd.donetsk.ua>

Try this:

/***********************************************************************/

• &1 - Owner
• &2 - Trigger Name

set newpage 0;
set space 0
set heading off;
set pagesize 0;
set linesize 100;
set echo off;
set feedback off;
set showmode off;
set verify off;
set termout off;
set maxdata 32000;
set long 31000;

spool &1._&2..Sql

column TRIGGER_BODY format A2000 Word_Wrapped

select 'Create Or Replace Trigger &1.&2' from dual; select substr(trigger_type,1,instr(trigger_type,' '))||' '||triggering_event||' ON '||table_name||' FOR '||substr(trigger_type,instr(trigger_type,' ')+1,255) ||' ' from all_triggers where owner=UPPER('&1') and trigger_name=UPPER('&2'); select Trigger_Body from all_triggers where owner=UPPER('&1') and trigger_name=UPPER('&2');
select '/' from dual;

Spool off;
set termout on;

/***********************************************************************/

Jim Katsos wrote:

> Does anyone have some pl/sql which generates trigger ddl from the
> dba_triggers view.
>
> --
> Jim Katsos
> Quest Software Pty Ltd
> http://www.quests.com
> tel +61 3 9811 8068
> mob 0411088578

---

 Константин Лаценюк
 Донецкая дирекция УСБ
 kwl_at_cbsd.donetsk.ua Received on Tue Jan 18 2000 - 07:40:17 CST