Advertisement
ExaGridDba

maximum row number that can be returned by dbms_rowid

Nov 24th, 2017
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.96 KB | None | 0 0
  1. maximum row number that can be returned by dbms_rowid
  2. 65535
  3.  
  4. SQL> select dbms_rowid.rowid_row_number('AAAAAAAAAAAAAAAAAA') from dual;
  5.  
  6. DBMS_ROWID.ROWID_ROW_NUMBER('AAAAAAAAAAAAAAAAAA')
  7. -------------------------------------------------
  8. 0
  9.  
  10. SQL> select dbms_rowid.rowid_row_number('AAAAAAAAAAAAAAAAAB') from dual;
  11.  
  12. DBMS_ROWID.ROWID_ROW_NUMBER('AAAAAAAAAAAAAAAAAB')
  13. -------------------------------------------------
  14. 1
  15.  
  16. SQL> select dbms_rowid.rowid_row_number('AAAAAAAAAAAAAAAP//') from dual;
  17.  
  18. DBMS_ROWID.ROWID_ROW_NUMBER('AAAAAAAAAAAAAAAP//')
  19. -------------------------------------------------
  20. 65535
  21.  
  22. SQL> select dbms_rowid.rowid_row_number('AAAAAAAAAAAAAAAQAA') from dual;
  23.  
  24. DBMS_ROWID.ROWID_ROW_NUMBER('AAAAAAAAAAAAAAAQAA')
  25. -------------------------------------------------
  26. 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement