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:
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
Thanks for sharing this informative article ,It would be helpful to all
Oracle Fusion HCM Online Training
Post a Comment