Re: Audit Trail - Can it include changed values?
From: Jennifer Brickner <brickner_at_vistachrome.com>
Date: 1996/06/17
Message-ID: <31C5B3E6.737E_at_vistachrome.com>#1/1
Date: 1996/06/17
Message-ID: <31C5B3E6.737E_at_vistachrome.com>#1/1
Dear Gene:
You can set this up in a jiffy if you use SQL to create the "CREATE TRIGGER" SQL. Below is a QUICK example.
select 'CREATE OR REPLACE TRIGGER '||TABLE_NAME||'_TRG ON UPDATE FOR
EACH ROW :NEW.USERNAME := USER; :OLD.TIME_STAMP := SYSDATE; END;' FROM
USER_TABLES;
Regards,
Jennifer
Received on Mon Jun 17 1996 - 00:00:00 CEST