Hi,
I have created one Audit table into which all the DML log entries are getting inserted.
below is the snapshot of audit table:
Table Name : AUDITTABLE
insert into dept1 values(50,'working','satara'); record 1
insert into dept1 values(60,'glassing','baramati'); record 2
In the above table i have inserted 2 records at same time at '23-02-2018 11:55:39' into dept1 table which is having only 3 columns deptno,dname and loc.
but, if i want to fetch the records from audittable then i can't differentiate the values like NEWVALUE is 50, so 50 belongs to which inserted record? whether it is for record 1 or record 2 in audit table.
Thank u,
Somdutt