请问各位大侠 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>
