Is there a way to reverse engineer transaction based on one IUD clause in transaction?
Hello,
Is there a way to find all IUD clauses in one transaction* based on the identitiy of one IUD SQL clause which is located in V$% dictionary views?
For example:
1. Transaction is consisted from
1.1
Insert Into T1
Update T2
Delete from T3
1.2 In V$ dictionary view we locate Update T2 set , ..where ...with host variables and constants
And on basis of this internal identification I would find
other two SQLs ( Insert, Delete ) on presumptions there is somewhere in the system recorded that
those 3 clauses happened in one commit operation.
2. Other example:
2.1 Insert Into T1...
Loop
Update T2
exit when...