Differences

This shows you the differences between two versions of the page.

--- dba:oracle:howtos:howto_flashback_query [2023/01/31 08:26] – removed - external edit (Unknown date) 127.0.0.1
+++ dba:oracle:howtos:howto_flashback_query [2023/01/31 08:26] (current) – ↷ Page moved from dba:oracle:howto_flashback_query to dba:oracle:howtos:howto_flashback_query dodger
@@ Line 1: / Line 1: @@
+====== [HOWTO] Flashback query ======
+This document only exists to write the SQL sentences explainded by burleson here: [[http://www.dba-oracle.com/t_rman_149_flasbback_query.htm]]
+\\
+But formatted and not as he uses to write with numbers or in-completion that will make the query unusable ... (fu***ng stupid).
+\\
+So here we go:
+<code sql>
+SELECT * FROM SCHEMA.TABLE
+as of timestamp to_timestamp('23-03-2020 11:00:00','dd-mm-yyyy hh24:mi:ss')
+WHERE SOME_FIELD LIKE 'SOME FILTER'
+/
+</code>
+\\
+What you have to know is that the ''as of timestamp'' must follow the ''from'' and before ''where'' sentence.
+\\
+cheers!