Visualizza wikitesto di FLASH BACK QUERY



SELECT COUNT(*) FROM SCHEMA.TABELLA AS OF TIMESTAMP TO_TIMESTAMP('2018-05-8 08:00:00', 'YYYY-MM-DD HH24:MI:SS');
 
SELECT COUNT(*) FROM SCHAMA.TABELLA;
  
CREATE TABLE SCHEMA.TABELLA_COPIA AS SELECT * FROM  BAAN.TABELLA WHERE 1=2;

 
INSERT INTO SCHEMA.TABELLA_COPIA SELECT * FROM  SCHEMA.TABELLA AS OF TIMESTAMP TO_TIMESTAMP('2018-05-8 08:00:00', 'YYYY-MM-DD HH24:MI:SS');
 
GRANT SELECT ON SCHEMA.TABELLA TO USER;