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/