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

0 comments:

Post a Comment