1 Nov 2019

Oracle DB how to...


How to revert commited changes in Oracle DB, as example:

MERGE INTO cos_translations d
     USING (select * from cos_translations as of timestamp timestamp '2015-12-08 17:00:00') 
     ON (d.id = o.id and d.asset_version=o.asset_version)
     WHEN MATCHED THEN
         UPDATE SET d.resource_value_en = o.resource_value_en, d.resource_value_ro = o.resource_value_ro;