How to track changes in Oracle table

How to track changes in Oracle table

In this post , we will be discuss about how to track changes in Oracle table. Track changes means , If we want to know old Data value of the Table as compared to the new Data Value. For Example, If we do keep , Insert or update operations on some table and now we want to track what was the table value or records 1 hour back then , we can use this below script to track changes in the Oracle table. Oracle has provided the feature of 'TIMESTAMP' using this , we can keep track the changes in oracle table. Here below is the complete detail about how to track changes in Oracle table.

How to track changes in Oracle table

Important Object to track changes in Oracle table

 'TIMESTAMP' is the main object ot track changes in Oracle Table.

Detail Script to track changes in Oracle table

Hi friends, In this post I will share you the SQL query by which you can also recover the Deleted and Updated Data in Oracle apps Tables.

Suppose I have an Oracle Apps Table FA_ASSET_INVOICES and I did some updates on 29-Jan-2018 for asset_id=7027 but due to issues I want to see data in the back dates for asset id 7027. For this You can use TIMESTAMP query to fetch the old data from the Tables in Oracle.

if you found this post helpful and you liked it then follow this blog to get notifications for the upcoming posts.

Example to track changes in Oracle table

SELECT * FROM fa_asset_invoices
AS OF TIMESTAMP
 TO_TIMESTAMP('2018-01-28 12:15:00', 'YYYY-MM-DD HH:MI:SS')
 WHERE asset_id=7027