Flashback version between query used to track a table row in a specified time period
Syntax: VERSIONS BETWEEN TIMESTAMP [lower bound] AND [upper bound];
Syntax: VERSIONS BETWEEN TIMESTAMP [lower bound] AND [upper bound];
eg:Where message_type = 'XXXX'
SELECT * FROM wf_notifications
VERSIONS BETWEEN TIMESTAMP TO_TIMESTAMP('15-AUG-2012 08:13:07')
AND TO_TIMESTAMP('15-AUG-2012 12:01:17')
No comments:
Post a Comment