dba:oracle:howtos:howto_flashback_query
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
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:// | ||
+ | \\ | ||
+ | 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(' | ||
+ | WHERE SOME_FIELD LIKE 'SOME FILTER' | ||
+ | / | ||
+ | </ | ||
+ | \\ | ||
+ | |||
+ | What you have to know is that the '' | ||
+ | \\ | ||
+ | cheers! | ||
dba/oracle/howtos/howto_flashback_query.txt · Last modified: 2023/01/31 08:26 by dodger