===========================================================
Retrieve rows in order inserted updated (ora_rowscn)
===========================================================
作者: xsb(http://xsb.itpub.net)
发表于:2007.05.09 11:49
分类: Oracle
出处：http://xsb.itpub.net/post/419/286503
---------------------------------------------------------------
发表于:2007.05.09 11:49
分类: Oracle
出处：http://xsb.itpub.net/post/419/286503
---------------------------------------------------------------
upgrading to Oracle 10g and using
CREATE TABLE ... ROWDEPENDENCIES.
That would be better called last touched, not inserted, because for example updates also affects ora_rowscn.
create table tt(id number);
insert into tt values(1);
select ora_rowscn from tt;
commit;
select ora_rowscn from tt;
insert into tt values(2);
select ora_rowscn from tt;
commit;
select ora_rowscn from tt;
create table ttt (id number) rowdependencies;
insert into ttt values(1);
select ora_rowscn from ttt;
commit;
select ora_rowscn from ttt;
insert into ttt values(2);
select ora_rowscn from ttt;
commit;
select ora_rowscn from ttt;
select to_char(scn_to_timestamp(ora_rowscn),'yyyymmdd hh24:mi:ssxff') from ttt;