User Tools

Site Tools


oracle:howto_flashback_query

Differences

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

Link to this comparison view

oracle:howto_flashback_query [2020/03/25 08:51] (current)
dodger created
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!
  
oracle/howto_flashback_query.txt ยท Last modified: 2020/03/25 08:51 by dodger