rowid 和 rownum 的区别!

请问各位大侠 rowid 和 rownum 的区别!------解决方法--------------------------------------------------

请问各位大侠 rowid 和 rownum 的区别!
------解决方法--------------------------------------------------------
不会,存放时系统已经排好了,一定是从1开始。
SQL> select * from eric_tmp
2 /

ID NAME
--------- --------------------
1 AAA
2 BBB
1 ABC
3 CCC
2 DDD
4


7 rows selected.

SQL> select rowid, rownum, t.* from eric_tmp t
2 /

ROWID ROWNUM ID NAME
------------------ --------- --------- --------------------
AABTPtAGjAAAH3NAAA 1 1 AAA
AABTPtAGjAAAH3NAAB 2 2 BBB
AABTPtAGjAAAH3NAAC 3 1 ABC
AABTPtAGjAAAH3NAAD 4 3 CCC
AABTPtAGjAAAH3NAAE 5 2 DDD
AABTPtAGjAAAH3NAAF 6 4
AABTPtAGjAAAH3NAAG 7

7 rows selected.

SQL> select rowid, rownum, t.* from eric_tmp t order by name
2 /

ROWID ROWNUM ID NAME
------------------ --------- --------- --------------------
AABTPtAGjAAAH3NAAA 1 1 AAA
AABTPtAGjAAAH3NAAC 3 1 ABC
AABTPtAGjAAAH3NAAB 2 2 BBB
AABTPtAGjAAAH3NAAD 4 3 CCC
AABTPtAGjAAAH3NAAE 5 2 DDD
AABTPtAGjAAAH3NAAF 6 4
AABTPtAGjAAAH3NAAG 7

7 rows selected.

SQL>