闪回技术之闪回版本查询

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/

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值