Архив

Публикации с меткой ‘rowid’

Получить данные о таблице по ROWID

select t.object_name,
       t.object_type,
       dbms_rowid.rowid_object('AABDKKAGRAAAOXhAAR')       as "OBJECT",
       dbms_rowid.rowid_relative_fno('AABDKKAGRAAAOXhAAR') as "FILE",
       dbms_rowid.rowid_block_number('AABDKKAGRAAAOXhAAR') as "BLOCK",
       dbms_rowid.rowid_row_number('AABDKKAGRAAAOXhAAR')   as "ROW"
from dba_objects t
where dbms_rowid.rowid_object('AABDKKAGRAAAOXhAAR') =  t.data_object_id

OBJECT_NAME     OBJECT_TYPE    OBJECT     FILE     BLOCK      ROW
--------------- -------------- ---------- -------- ---------- ----------
FM_FORM_MST_B   TABLE          275082     401      58849      17
Categories: SQL Tags: ,