Can this be done using analytics?
From: Eugene Pipko <eugene.pipko_at_unionbay.com>
Date: Mon, 4 Apr 2011 12:17:36 -0700
Message-ID: <34DB87F47199374280ADFD2968CDBCFA8865B84E05_at_MAIL01KT.seattlepacificindustries.com>
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?
Date: Mon, 4 Apr 2011 12:17:36 -0700
Message-ID: <34DB87F47199374280ADFD2968CDBCFA8865B84E05_at_MAIL01KT.seattlepacificindustries.com>
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_at_01CBF2C2.124DFFF0]
Thanks,
Eugene
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 04 2011 - 14:17:36 CDT