ROWID_INFO Procedure

This procedure returns information about a ROWID, including its type (restricted or extended), and the components of the ROWID. This is a procedure, and it cannot be used in a SQL statement.

Syntax

DBMS_ROWID.ROWID_INFO (
   rowid_in         IN   ROWID, #输入参数
   ts_type_in       IN   VARCHAR2 DEFAULT 'SMALLFILE',
   rowid_type       OUT  NUMBER,#下列几个参数全是输出 参数
   object_number    OUT  NUMBER,
   relative_fno     OUT  NUMBER,
   block_number     OUT  NUMBER,
   row_number       OUT  NUMBER);

Pragmas

pragma RESTRICT_REFERENCES(rowid_info,WNDS,RNDS,WNPS,RNPS);

Parameters

根据上面编写dbms_rowid.rowid_info的plsql，对于要输入与输出的参数全要定义变量，默认参数可以不用定义对应变量

SQL> r
  1  declare
  2  v_rowid rowid;
  3  v_rowid_type number;
  4  v_object_number number;
  5  v_relative_fno number;
  6  v_block_number number;
  7  v_row_number number;
  8  begin
  9  select rowid into v_rowid from scott.emp where rownum<2;#得到输入变量v_rowid，把它传递给dbms_rowid.rowid_info过程
 10  dbms_rowid.rowid_info(v_rowid,v_rowid_type,v_object_number,v_relative_fno,v_block_number,v_row_number);dbms_output.put_line('row id is: '||v_rowid);
 11  dbms_output.put_line('rowid type is: '||v_rowid_type);#此处测试仅显示1-2个输出参数，其它同理
 12* end;
row id is: AAAMlsAAEAAAAAfAAA
rowid type is: 1

PL/SQL procedure successfully completed.

SQL>