SQL> create table t1 (id number,name varchar2(10));

Table created.
SQL> insert into t1 values(1,'a');

1 row created.

SQL> insert into t1 values(2,'a');

1 row created.

SQL> insert into t1 values(3,'a');

1 row created.

SQL> commit;
SQL> select * from t1 order by name;

        ID NAME
---------- ----------
         1 a
         3 a
         2 a

SQL> select * from t1 order by name;

        ID NAME
---------- ----------
         1 a
         3 a
         2 a

SQL> select rownum,rowid,id,name from t1 order by name;

    ROWNUM ROWID                      ID NAME
---------- ------------------ ---------- ----------
         1 AABsyUAABAAAvShAAA          1 a
         3 AABsyUAABAAAvShAAC          3 a
         2 AABsyUAABAAAvShAAB          2 a

SQL>  select rownum,rowid,id,name from t1 order by rowid;

    ROWNUM ROWID                      ID NAME
---------- ------------------ ---------- ----------
         1 AABsyUAABAAAvShAAA          1 a
         2 AABsyUAABAAAvShAAB          2 a
         3 AABsyUAABAAAvShAAC          3 a
SQL> insert into t1 values(4,'b');

1 row created.
SQL> commit;

Commit complete.

SQL> select rownum,rowid,id,name from t1 order by name;

    ROWNUM ROWID                      ID NAME
---------- ------------------ ---------- ----------
         1 AABsyUAABAAAvShAAA          1 a
         2 AABsyUAABAAAvShAAB          2 a
         3 AABsyUAABAAAvShAAC          3 a
         4 AABsyUAABAAAvShAAD          4 b

SQL> alter system flush shared_pool;

System altered.

SQL>  select rownum,rowid,id,name from t1 order by name;

    ROWNUM ROWID                      ID NAME
---------- ------------------ ---------- ----------
         1 AABsyUAABAAAvShAAA          1 a
         2 AABsyUAABAAAvShAAB          2 a
         3 AABsyUAABAAAvShAAC          3 a
         4 AABsyUAABAAAvShAAD          4 b

SQL> delete from t1 where id =4;

1 row deleted.

SQL> commit;

Commit complete.

SQL>  alter system flush shared_pool;

System altered.

SQL>  select rownum,rowid,id,name from t1 order by name;

    ROWNUM ROWID                      ID NAME
---------- ------------------ ---------- ----------
         1 AABsyUAABAAAvShAAA          1 a
         3 AABsyUAABAAAvShAAC          3 a
         2 AABsyUAABAAAvShAAB          2 a

复制

确实很神奇