Flashback Table and Update the data from temporary table

Flashback Table and Update the data from temporary table

--CREATE FLASHBACK TABLE
CREATE TABLE TABLE_NAME_TEMP AS
SELECT *
FROM TABLE_NAME AS OF TIMESTAMP TO_TIMESTAMP('YYYY-MM-DD HH:MI:SS', 'YYYY-MM-DD HH:MI:SS');

--UPDATE FROM FLASHBACK TABLE
UPDATE TABLE_NAME
SET COLUMN_NAME   = 'VALUE'
WHERE COLUMN_NAME = 'VALUE'
AND ID_COLUMN    IN
  (SELECT ID_COLUMN
  FROM TABLE_NAME_TEMP
  WHERE COLUMN_NAME = 'VALUE'
  AND COLUMN_NAME   = 'VALUE'
  );

Comments