Re: Audit Trail - Can it include changed values?

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