Custom Search

Monday, June 7, 2010

Flashback Query

Select * from table as of SCN timestamp_to_scn (systimestamp-1/1440)

it will retreave before 1 min. data
Posted by We are here for Solution at 12:25 PM

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)