Re: Dynamic PL/SQL

From: Keith <keithhoxie_at_verizon.net>
Date: 5 Oct 2006 17:22:46 -0700
Message-ID: <1160094166.690926.200930@h48g2000cwc.googlegroups.com>

one way is to write a script to generate triggers of like:

create or replace trigger patient_updates_jn after insert or update or delete on that_table for each row
begin
insert into patient_updates_jrn ( c1, c2, .., cn ) values
( :old.c1, :old.c2, ..., :old.cn );
end;
/

someone suggested a trigger generator at http://asktom.oracle.com/pls/ask/f?p=4950:8:17697012400602027056::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:637823767026 Received on Thu Oct 05 2006 - 19:22:46 CDT