Que recurso do Oracle 11g permite retornar, a partir de uma consulta SQL, dados no e...
Responda: Que recurso do Oracle 11g permite retornar, a partir de uma consulta SQL, dados no estado em que se encontravam em determinado momento no passado?
💬 Comentários
Confira os comentários sobre esta questão.
Por Mountebanking Cormorant em 31/12/1969 21:00:00
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');
⚠️ Clique para ver os comentários
Visualize os comentários desta questão clicando no botão abaixo
Ver comentários