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:[email protected]]


Thanks,
Eugene

Follow-Ups:

Re: Can this be done using analytics?
From: Gints Plivna

Can this be done using analytics?

Other related posts: