Oracle Db Enterprise | Edition Hot!

-- Wait a moment (simulating time passing) EXEC DBMS_LOCK.SLEEP(5);

-- Insert initial data INSERT INTO transactions VALUES (1, 101, 500.00, SYSTIMESTAMP, 'COMPLETED'); COMMIT; oracle db enterprise edition

This utilizes DBMS_FLASHBACK_ARCHIVE and Optimization for Flashback Data Archive, which requires Enterprise Edition. -- Wait a moment (simulating time passing) EXEC DBMS_LOCK