闪回技术之闪回版本查询

SQL> conn test/test;

Connected.

SQL> create table mytest2 (name varchar2(20),email varchar2(30));

Table created.

SQL> insert into mytest2 values ('mingming','lsm_3036@163.com');

1 row created.

SQL> insert into mytest2 values ('liangliang','liangliang@163.com');

1 row created.

SQL> commit;

Commit complete.

SQL> select * from test.mytest2;

NAME                 EMAIL

-------------------- ------------------------------

mingming             lsm_3036@163.com

liangliang           liangliang@163.com

SQL> update mytest2 set name='weiwei' where name='liangliang';

1 row updated.

SQL> commit;

Commit complete.

SQL> select versions_starttime, versions_endtime, versions_xid,

versions_operation,name,email

from mytest2 versions between timestamp

to_date('19/03/2014 09:39:00', 'dd/mm/yyyy hh24:mi:ss')

and maxvalue

order by VERSIONS_STARTTIME;  2    3    4    5    6 

VERSIONS_STARTTIME

---------------------------------------------------------------------------

VERSIONS_ENDTIME

---------------------------------------------------------------------------

VERSIONS_XID     V NAME                 EMAIL

---------------- - -------------------- ------------------------------

19-MAR-14 09.39.20 AM

1700130074000000 U weiwei               liangliang@163.com

19-MAR-14 09.39.20 AM

                   liangliang           liangliang@163.com

VERSIONS_STARTTIME

---------------------------------------------------------------------------

VERSIONS_ENDTIME

---------------------------------------------------------------------------

VERSIONS_XID     V NAME                 EMAIL

---------------- - -------------------- ------------------------------

                   mingming             lsm_3036@163.com

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/31448824/viewspace-2137533/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/31448824/viewspace-2137533/