Can this be done using analytics?

From: Eugene Pipko <>
Date: Mon, 4 Apr 2011 12:17:36 -0700
Message-ID: <>

Hi all,
Oracle 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:



Received on Mon Apr 04 2011 - 14:17:36 CDT

Original text of this message