测试Oracle中插入数据是无序的:
开二个session:
1.在session1中执行:
SQL> drop table test6;
Table dropped.
SQL> create table test6(id number);
Table created.
SQL> insert into test6 values(1);
1 row created.
SQL> insert into test6 values(2);
1 row created.
SQL> commit;
Commit complete.
SQL> select * from test6;
ID
1
2
2.在session2中执行:
SQL> insert into test6 values(3);
1 row created.
SQL> insert into test6 values(4);
1 row created.
SQL> commit;
Commit complete.
3.然后在到session1中执行:
SQL> insert into test6 values(5);
1 row created.
SQL> commit;
Commit complete.
SQL> select * from test6;
ID
1
2
5
3
4
从查询结果看出,按道理1,2先插入