Difference between revisions of "Flashback Query"
Jump to navigation
Jump to search
(Created page with "* Demo <pre> -- Create a test table CREATE TABLE tbl_flashback_test( id NUMBER(10) ); -- Check the current date/time or SCN SQL> SELECT current_scn, TO_CHAR(SYSTIMESTAMP, 'YY...") |
|||
| Line 1: | Line 1: | ||
| − | * | + | * Prepare a sample table |
<pre> | <pre> | ||
-- Create a test table | -- Create a test table | ||
| Line 25: | Line 25: | ||
---------- | ---------- | ||
1 | 1 | ||
| − | + | </pre> | |
* Difference ways to perform Flashback Query | * Difference ways to perform Flashback Query | ||
| Line 53: | Line 53: | ||
0 | 0 | ||
</pre> | </pre> | ||
| + | |||
| + | [[Category:Database_Features]] | ||
Revision as of 09:15, 11 March 2011
- Prepare a sample table
-- Create a test table
CREATE TABLE tbl_flashback_test(
id NUMBER(10)
);
-- Check the current date/time or SCN
SQL> SELECT current_scn, TO_CHAR(SYSTIMESTAMP, 'YYYY-MM-DD HH24:MI:SS')
FROM v$database;
CURRENT_SCN TO_CHAR(SYSTIMESTAM
----------- -------------------
722452 2008-09-03 10:22:37
-- Perform an action (insert)
SQL> INSERT INTO tbl_flashback_test(id) VALUES (1);
COMMIT;
-- Check the LATEST content
SQL> SELECT COUNT(*) FROM tbl_flashback_test;
COUNT(*)
----------
1
- Difference ways to perform Flashback Query
-- Using SCN
SELECT COUNT(*) FROM tbl_flashback_test
AS OF SCN 722452;
COUNT(*)
----------
0
-- Using TIMESTAMP
SELECT COUNT(*) FROM tbl_flashback_test
AS OF TIMESTAMP TO_TIMESTAMP('2008-09-03 10:22:37', 'YYYY-MM-DD HH24:MI:SS');
COUNT(*)
----------
0
-- Using TIMESTAMP and INTERVAL
SELECT COUNT(*) FROM tbl_flashback_test
AS OF TIMESTAMP SYSTIMESTAMP - INTERVAL '4' MINUTE;
COUNT(*)
----------
0
