Oracle的rowid

select rowid from test_block_num where rownum=1;

select DBMS_ROWID.ROWID_OBJECT('&rowid') data_object_id#,
       DBMS_ROWID.ROWID_RELATIVE_FNO('&rowid') rfile#,
       DBMS_ROWID.ROWID_BLOCK_NUMBER('&rowid') block#,
       DBMS_ROWID.ROWID_ROW_NUMBER('&rowid') row#
from dual;

& 多次

select rowid from test_block_num where rownum=1;

select DBMS_ROWID.ROWID_OBJECT('&&rowid') data_object_id#,
       DBMS_ROWID.ROWID_RELATIVE_FNO('&&rowid') rfile#,
       DBMS_ROWID.ROWID_BLOCK_NUMBER('&&rowid') block#,
       DBMS_ROWID.ROWID_ROW_NUMBER('&&rowid') row#
from dual;

&& 一次

col owner format a10
col object_name format a20
select owner, object_name from dba_objects where object_id=&data_object_id;

col file_name format a40
col tablespace_name format a30
select file_name, tablespace_name from dba_data_files where file_id=&rfile;