I have a table column update once or twice per minute, how this column data statistics for five consecutive minutes unchanged data details

CodePudding user response:

The best way is to log, 1 to 2 times per minute are not frequent,
If it is occasionally check can try flashback queries,

CodePudding user response:

reference 1st floor oracle_awen response:

is the best way to record log, 1 to 2 times per minute are not frequent,
If it is occasionally check can try flashback queries,

Only use the SQL can be found out, let write a SQL

CodePudding user response:

Mark the

CodePudding user response:

A reply to the wrong place,,
Query data from a certain point in time, like:
Select * from tab_test AS OF TIMESTAMP to_timestamp (' 20140917 10:00:00 ', 'yyyymmdd hh24: mi: ss');

CodePudding user response:

This is mark column column itself? So, with the column itself directly filter?

CodePudding user response:

You this is to check the snapshot, the meaning of the original poster, the data change is captured within 5 minutes, personal feel log is used to record, and then in a change record to itself and compares,

Select * from tab_test AS OF TIMESTAMP to_timestamp (' 20140917 10:00:00 ', 'yyyymmdd hh24: mi: ss');