SQL & PL/SQL

Hello,

I would like to record any change in my data using triggers.

For Example, I have the following tables:

create table members
( member_id number,
name varchar2(100),
password varchar2(100),
address varchar2(100),
some other attributes ...
)

and

create table members_audit
( counter_seq number
stamp date,
action varchar2(1),
member_id number,
name varchar2(100),
password varchar2(100),
address varchar2(100),
some other attributes ...
)


Now, I would like to create a trigger that records and saves every change.
But only if there has really something changed.

Therefore, I got to compare every single OLD variable with the NEW variable. Is there a possibility to simply pass every single colum of the OLD variable and the NEW variable in a loop?

Do I have to create an extra trigger for each table or can I do something like this:

Create the following trigger for each table:

CREATE OR REPLACE TRIGGER my_trigger AFTER INSERT OR DELETE OR UPDATE ON [every_table] FOR EACH ROW


The whole auditing-table name is put together using the table name plus "_audit":

So, for example if I have the table "members" the trigger auditing table should be "memebers_audit". My auditing table for the table "customers" is "customers_audit". I do not want to create a trigger for every table manually.
Can I create a trigger on the whole schema?

How can I solve this problem?

Thank you in advance,

Christian