Monday 29 January 2018

How to Recover Deleted and Updated Data in Oracle Tables




How to Recover Deleted Data in Oracle Tables



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.

For Example:-


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

2 comments:

Rifath said...

Excellent blog I visit this blog it's really awesome. The important thing is that in this blog content written clearly and understandable. The content of information is very informative.
¬Oracle Fusion HCM Online Training

shaik shah said...

Thanks for sharing this informative article ,It would be helpful to all
Oracle Fusion HCM Online Training

Post a Comment

Contact us for any Collaboration, Project Support & On Job Support Work

Name

Email *

Message *