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: