Can this be done using analytics?
- From: Eugene Pipko <eugene.pipko@xxxxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 4 Apr 2011 12:17:36 -0700
Hi all,
Oracle 9.2.0.8 on Windows 2K3.
I have a vendor's audit table which gets populated every time a user opens a PO
form, for instance.
Many times there is no change reflected in the audit, however, when user does
make a change to the PO, the new values are written into the audit.
My question is: how can I build a view of what was changed on what day using
Oracle's analytics. I know I can use lag(), but I will need to compare all
rows, not just prior to current.
Can this be done in sql?
Here is the snippet of the table:
[cid:image002.png@01CBF2C2.124DFFF0]
Thanks,
Eugene
Other related posts:
