Oracle中數(shù)據(jù)塊中row number缺失該怎么辦，很多新手對(duì)此不是很清楚，為了幫助大家解決這個(gè)難題，下面小編將為大家詳細(xì)講解，有這方面需求的人可以來(lái)學(xué)習(xí)下，希望你能有所收獲。

創(chuàng)新互聯(lián)建站是一家專(zhuān)業(yè)提供涼山州企業(yè)網(wǎng)站建設(shè),專(zhuān)注與成都網(wǎng)站制作、網(wǎng)站設(shè)計(jì)、H5場(chǎng)景定制、小程序制作等業(yè)務(wù)。10年已為涼山州眾多企業(yè)、政府機(jī)構(gòu)等服務(wù)。創(chuàng)新互聯(lián)專(zhuān)業(yè)網(wǎng)絡(luò)公司優(yōu)惠進(jìn)行中。

環(huán)境1：

1. SCOTT@proc> drop table tt purge;

3. Table dropped.

5. SCOTT@proc>

6. SCOTT@proc>

7. SCOTT@proc> create table tt (id int,name varchar2(2000)) tablespace users;

9. Table created.

11. SCOTT@proc> insert into tt values(1,rpad('a',1800,'+'));

13. 1 row created.

15. SCOTT@proc> insert into tt values(2,rpad('b',1800,'+'));

17. 1 row created.

19. SCOTT@proc> insert into tt values(3,rpad('c',1800,'+'));

21. 1 row created.

23. SCOTT@proc> insert into tt values(4,rpad('d',1800,'+'));

25. 1 row created.

27. SCOTT@proc> commit;

29. Commit complete.

31. SCOTT@proc> select id,substr(name,1,1),rowid,dbms_rowid.rowid_relative_fno(rowid) file#,dbms_rowid.rowid_block_number(rowid) block#,dbms_rowid.rowid_row_number(rowid) row# from tt;

33.         ID SU ROWID                   FILE#     BLOCK#       ROW#

34. ---------- -- ------------------ ---------- ---------- ----------

35.          1 a   AAAV8LAAEAAAAImAAA           4          550          0

36.          2 b   AAAV8LAAEAAAAImAAB           4          550          1

37.          3 c   AAAV8LAAEAAAAImAAC           4          550          2

38.          4 d   AAAV8LAAEAAAAImAAD           4          550          3

40. SCOTT@proc> delete from tt where id=2;

42. 1 row deleted.

44. SCOTT@proc> commit;

46. Commit complete.

48. SCOTT@proc> insert into tt values(5,rpad('e',1800,'+'));

50. 1 row created.

52. SCOTT@proc> commit;

54. Commit complete.

56. SCOTT@proc> select id,substr(name,1,1),rowid,dbms_rowid.rowid_relative_fno(rowid) file#,dbms_rowid.rowid_block_number(rowid) block#,dbms_rowid.rowid_row_number(rowid) row# from tt;

58.         ID SU ROWID                   FILE#     BLOCK#       ROW#

59. ---------- -- ------------------ ---------- ---------- ----------

60.          1 a  AAAV8LAAEAAAAImAAA           4          550          0

61.          5 e   AAAV8LAAEAAAAImAAB           4        550          1

62.          3 c   AAAV8LAAEAAAAImAAC           4          550          2

63.          4 d   AAAV8LAAEAAAAImAAD          4          550          3

環(huán)境2：

1. SCOTT@proc> drop table tt purge;
   

2. 
   

3. Table dropped.
   

4. 
   

5. SCOTT@proc> create table tt (id int,name varchar2(2000)) tablespace users;
   

6. 
   

7. Table created.
   

8. 
   

9. SCOTT@proc> insert into tt values(1,rpad('a',1800,'+'));
   

10. 
    

11. 1 row created.
    

12. 
    

13. SCOTT@proc> insert into tt values(2,rpad('b',1800,'+'));
    

14. 
    

15. 1 row created.
    

16. 
    

17. SCOTT@proc> insert into tt values(3,rpad('c',1800,'+'));
    

18. 
    

19. 1 row created.
    

20. 
    

21. SCOTT@proc> commit;
    

22. 
    

23. Commit complete.
    

24. 
    

25. SCOTT@proc> select id,substr(name,1,1),rowid,dbms_rowid.rowid_relative_fno(rowid) file#,dbms_rowid.rowid_block_number(rowid) block#,dbms_rowid.rowid_row_number(rowid) row# from tt;
    

26. 
    

27.         ID SU ROWID                   FILE#     BLOCK#       ROW#
    

28. ---------- -- ------------------ ---------- ---------- ----------
    

29.          1 a   AAAV8VAAEAAAAIkAAA           4          548          0
    

30.          2 b   AAAV8VAAEAAAAIkAAB          4          548          1
    

31.          3 c  AAAV8VAAEAAAAIkAAC          4          548          2
    

32. 
    

33. SCOTT@proc> delete from tt where id=2;
    

34. 
    

35. 1 row deleted.
    

36. 
    

37. SCOTT@proc> insert into tt values(4,rpad('d',1800,'+'));
    

38. 
    

39. 1 row created.
    

40. 
    

41. SCOTT@proc> commit;
    

42. 
    

43. Commit complete.
    

44. 
    

45. SCOTT@proc> insert into tt values(5,rpad('e',1800,'+'));
    

46. 
    

47. 1 row created.
    

48. 
    

49. SCOTT@proc> commit;
    

50. 
    

51. Commit complete.
    

52. 
    

53. SCOTT@proc> select id,substr(name,1,1),rowid,dbms_rowid.rowid_relative_fno(rowid) file#,dbms_rowid.rowid_block_number(rowid) block#,dbms_rowid.rowid_row_number(rowid) row# from tt;
    

54. 
    

55.         ID SU ROWID                   FILE#     BLOCK#       ROW#
    

56. ---------- -- ------------------ ---------- ---------- ----------
    

57.          1 a   AAAV8VAAEAAAAIkAAA          4          548          0
    

58.          3 c  AAAV8VAAEAAAAIkAAC           4         548          2
    

59.          4 d  AAAV8VAAEAAAAIkAAD           4          548          3
    

60.          5 e  AAAV8VAAEAAAAIkAAE          4         548          4
    

61. 
    

62. SCOTT@proc>

環(huán)境3：

1. SCOTT@proc> drop table tt purge;

3. Table dropped.

5. SCOTT@proc> create table tt (id int,name varchar2(2000)) tablespace users;

7. Table created.

9. SCOTT@proc> insert into tt values(1,rpad('a',1800,'+'));

11. 1 row created.

13. SCOTT@proc> insert into tt values(2,rpad('b',1800,'+'));

15. 1 row created.

17. SCOTT@proc> insert into tt values(3,rpad('c',1800,'+'));

19. 1 row created.

21. SCOTT@proc> commit;

23. Commit complete.

25. SCOTT@proc> select id,substr(name,1,1),rowid,dbms_rowid.rowid_relative_fno(rowid) file#,dbms_rowid.rowid_block_number(rowid) block#,dbms_rowid.rowid_row_number(rowid) row# from tt;

27.         ID SU ROWID                   FILE#     BLOCK#       ROW#

28. ---------- -- ------------------ ---------- ---------- ----------

29.          1 a  AAAV8MAAEAAAAImAAA          4          550          0

30.          2 b  AAAV8MAAEAAAAImAAB          4         550          1

31.          3 c   AAAV8MAAEAAAAImAAC          4          550          2

33. SCOTT@proc> delete from tt where id=2;

35. 1 row deleted.

37. SCOTT@proc> commit;

39. Commit complete.

41. SCOTT@proc> insert into tt values(4,rpad('d',1800,'+'));

43. 1 row created.

45. SCOTT@proc> insert into tt values(5,rpad('e',1800,'+'));

47. 1 row created.

49. SCOTT@proc> commit;

51. Commit complete.

53. SCOTT@proc> select id,substr(name,1,1),rowid,dbms_rowid.rowid_relative_fno(rowid) file#,dbms_rowid.rowid_block_number(rowid) block#,dbms_rowid.rowid_row_number(rowid) row# from tt;

55.         ID SU              ROWID      FILE#     BLOCK#       ROW#

56. ---------- -- ------------------ ---------- ---------- ----------

57.          1 a   AAAV8MAAEAAAAImAAA           4          550          0

58.          5 e   AAAV8MAAEAAAAImAAB           4          550          1

59.          3 c   AAAV8MAAEAAAAImAAC           4          550          2

60.          4 d   AAAV8MAAEAAAAImAAD           4          550          3

看完上述內(nèi)容是否對(duì)您有幫助呢？如果還想對(duì)相關(guān)知識(shí)有進(jìn)一步的了解或閱讀更多相關(guān)文章，請(qǐng)關(guān)注創(chuàng)新互聯(lián)行業(yè)資訊頻道，感謝您對(duì)創(chuàng)新互聯(lián)的支持。