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


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

Original text of this message