rowid含义

02:23:38 scott@prod> select rowid,deptno,dname,loc from dept;

ROWID                     DEPTNO DNAME          LOC
------------------ ------------- -------------- -------------
AAAVRCAAEAAAACHAAA            10 ACCOUNTING     NEW YORK
AAAVRCAAEAAAACHAAB            20 RESEARCH       DALLAS
AAAVRCAAEAAAACHAAC            30 SALES          CHICAGO
AAAVRCAAEAAAACHAAD            40 OPERATIONS     BOSTON


AAAVRC AAE AAAACH AAD
这个是64进制的数
object_id AAAVRC  10进制=21*64^2+17*64^1+2*64^0=86016+1088+2=86106
file#     AAE     10进制=4
block#    AAAACH  10进制=2*64^1+7=135
row       AAD     10进制=3

我们也可以使用oracle提供的dbms_rowid的包来进行查询
select dbms_rowid.rowid_object('AAAVRCAAEAAAACHAAD') data_object_id#,
       dbms_rowid.rowid_relative_fno('AAAVRCAAEAAAACHAAD') rfile#,
       dbms_rowid.rowid_block_number('AAAVRCAAEAAAACHAAD') block#,
       dbms_rowid.rowid_row_number('AAAVRCAAEAAAACHAAD') row# from dual;
DATA_OBJECT_ID#        RFILE#        BLOCK#          ROW#
--------------- ------------- ------------- -------------
          87106             4           135             3