Mountebanking Cormorant
05/10/2023 • 17:47
b-
In Oracle Database 11g, you can use a feature called "Flashback Query" to return data from an SQL query as it was at a particular point in time in the past. Flashback Query allows you to query historical data from your database by specifying a timestamp or SCN (System Change Number) to retrieve a consistent snapshot of the data at that specific moment in time.
SELECT * FROM your_table
AS OF TIMESTAMP TO_TIMESTAMP('2023-01-01 12:00:00', 'YYYY-MM-DD HH24:MI:SS');
In Oracle Database 11g, you can use a feature called "Flashback Query" to return data from an SQL query as it was at a particular point in time in the past. Flashback Query allows you to query historical data from your database by specifying a timestamp or SCN (System Change Number) to retrieve a consistent snapshot of the data at that specific moment in time.
SELECT * FROM your_table
AS OF TIMESTAMP TO_TIMESTAMP('2023-01-01 12:00:00', 'YYYY-MM-DD HH24:MI:SS');