我小测试了一下,但不能肯定是否全部如此:
create table test (a1 number(5),a2 number(5));
insert into test values(1,1);
commit;
select * from test where rowid=(select max(rowid) from test);
A1
A2
1
1
insert into test values(2,2);
commit;
select * from test where rowid=(select max(rowid) from test);
A1
A2
2
2
insert into test values(3,3);
insert into test values(4,4);
commit;
select * from test where rowid=(select max(rowid) from test);
A1
A2
4
4