Oracle Audit Report 1

[Johnsf]

Hi,

I have a table "TClIENT" on which I have auditing turned on in Oracle so I have a "TCLIENT_A" table too.

TCLIENT has the fields Name, Address1, Address2, etc. There are about 10000 client records on this table.

I want to write a report that will find where any changes have been done to a particular client and report which field (Name, Address1, Address2) has been changed for that client.

Any ideas how I can do this?

Cheers,

John

 

[lbass]

You could try linking tclient to tclient_A on the clientID. This should return only those clients that have had changes in their information. You could then place {tclient.name} and {tclient_A.name} in detail_a, {tclient.address1} and {tclient_A.address1} in detail_b, etc. Then format each detail section to suppress based on the appropriate condition, as in the following for name:

{tclient.name} = {tclient_A.name}

I think that should return only those records that have changed.

-LB