【例1】
SQL>set time on
SQL>create table hr.mydep1 as select * from hr.department;
SQL>delete from hr.mydep1 where department_id=10;
SQL>flashback table hr.mydep1 to timestamp
2 to timestamp(to_tate(‘2009-05-29 10:00:00’, ’yyyy-mm-dd hh24:mi:ss’));
【例2】
SQL>create table student (name Varchar2(10), score Number);
SQL>insert into student values(‘zs’, 68);
SQL>update student set score=98 where name=’zs’;
SQL>commit;
SQL>select versions_starttime,versions_operation,name,score
2 from student versions between timestamp minvalue and maxvalue;
【例3】
SQL>CONNECT sys /zzuli AS sysdba
SQL>select table_name, undo_sql from flashback_transaction_query where rownum<5;