text: ----------------------------------------------------------------------------
  --  Trivadis AG, Infrastructure Managed Services
  --  Saegereistrasse 29, 8152 Glattbrugg, Switzerland
  ----------------------------------------------------------------------------
  --  Name......: rowid.sql
  --  Author....: Stefan Oehrli (oes) stefan.oehrli@trivadis.com
  --  Editor....: Stefan Oehrli
  --  Date......: 2018.10.24
  --  Revision..:  
  --  Purpose...: Audit trail size
  --  Notes.....:  
  --  Reference.: SYS (or grant manually to a DBA)
  --  License...: Licensed under the Universal Permissive License v 1.0 as 
  --              shown at http://oss.oracle.com/licenses/upl.
  ----------------------------------------------------------------------------
  --  Modified..:
  --  see git revision history for more information on changes/updates
  ----------------------------------------------------------------------------
  SELECT
       decode(dbms_rowid.ROWID_TYPE (rowid),0,'restricted', 1 ,'extended')  type
      , dbms_rowid.ROWID_OBJECT (rowid) object#
      , dbms_rowid.ROWID_RELATIVE_FNO(rowid) rfile#
      , dbms_rowid.ROWID_BLOCK_NUMBER(rowid) block#
      , dbms_rowid.ROWID_ROW_NUMBER(rowid)   row#
      , rowid
  FROM
      &1
  WHERE
      &2
  /
  
  
  