dba:oracle:howtos:howto_flashback_query
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Last revisionBoth sides next revision | ||
dba:oracle:howto_flashback_query [2022/02/11 11:12] – ↷ Page moved from oracle:howto_flashback_query to dba:oracle:howto_flashback_query dodger | dba:oracle:howtos:howto_flashback_query [2023/01/31 08:26] – removed - external edit (Unknown date) 127.0.0.1 | ||
---|---|---|---|
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