Logging queries in oracle 8.1.7
From: sachin <sachin_mahajan_at_hotmail.com>
Date: 2 Jan 2003 11:26:14 -0800
Message-ID: <2317671a.0301021126.3d842f82_at_posting.google.com>
Date: 2 Jan 2003 11:26:14 -0800
Message-ID: <2317671a.0301021126.3d842f82_at_posting.google.com>
Hi Gurus:
Is there any convenient way to log queries in oracle (preferably
triggers)? I have a table which has changeby, changedate and
primarykey. whenever a user accesses that i want to stick in that row
accessed (changeby, changedate and primarykey) into another table. If
the user is inserting updating or deleting i can easily log it using
triggers.
Thanks,