Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- maximum row number that can be returned by dbms_rowid
- 65535
- SQL> select dbms_rowid.rowid_row_number('AAAAAAAAAAAAAAAAAA') from dual;
- DBMS_ROWID.ROWID_ROW_NUMBER('AAAAAAAAAAAAAAAAAA')
- -------------------------------------------------
- 0
- SQL> select dbms_rowid.rowid_row_number('AAAAAAAAAAAAAAAAAB') from dual;
- DBMS_ROWID.ROWID_ROW_NUMBER('AAAAAAAAAAAAAAAAAB')
- -------------------------------------------------
- 1
- SQL> select dbms_rowid.rowid_row_number('AAAAAAAAAAAAAAAP//') from dual;
- DBMS_ROWID.ROWID_ROW_NUMBER('AAAAAAAAAAAAAAAP//')
- -------------------------------------------------
- 65535
- SQL> select dbms_rowid.rowid_row_number('AAAAAAAAAAAAAAAQAA') from dual;
- DBMS_ROWID.ROWID_ROW_NUMBER('AAAAAAAAAAAAAAAQAA')
- -------------------------------------------------
- 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement