Using A Trigger In Oracle To Log Changes To A Table

I have a project for one of my classes. We need to create a log when two of our tables have changes made to them: insert/update/delete. We are required to use Oracle Triggers and P

Solution 1:

There are two pseudocolumns: uid and user, you can use them in your values clause and the following sql returns the ip address of the client:

SELECT SYS_CONTEXT('USERENV','IP_ADDRESS') FROM dual;