eOracle: DBA blog
Learning Oracle everyday
Saturday, June 14, 2008
How to see what is committed in table (in past)
Here is the query to see the result of 2 days before. Interval might be day, hour, minute, second
etc.
SELECT * FROM Table1
AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '2' day)
WHERE site_code = 'ITACS';
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment