VIEW: MDSYS.USER_SDO_TOPO_INFO

Source

View Text - Preformatted

SELECT SDO_OWNER OWNER,
       Topology,
       Topology_id,
       Tolerance,
       SRID,
       b.owner Table_Schema,
       b.Table_Name Table_Name,
       b.Column_Name Column_Name,
       b.Layer_ID TG_Layer_ID,
       b.Layer_Type TG_Layer_Type,
       b.Layer_Level TG_Layer_Level,
       b.Child_Layer_id Child_Layer_id,
       Digits_Right_Of_Decimal
FROM SDO_TOPO_METADATA_TABLE a,
     TABLE (a.Topo_Geometry_Layers) b
WHERE  sdo_owner = sys_context('userenv', 'CURRENT_SCHEMA')

View Text - HTML Formatted

SELECT SDO_OWNER OWNER
, TOPOLOGY
, TOPOLOGY_ID
, TOLERANCE
, SRID
, B.OWNER TABLE_SCHEMA
, B.TABLE_NAME TABLE_NAME
, B.COLUMN_NAME COLUMN_NAME
, B.LAYER_ID TG_LAYER_ID
, B.LAYER_TYPE TG_LAYER_TYPE
, B.LAYER_LEVEL TG_LAYER_LEVEL
, B.CHILD_LAYER_ID CHILD_LAYER_ID
, DIGITS_RIGHT_OF_DECIMAL FROM SDO_TOPO_METADATA_TABLE A
, TABLE (A.TOPO_GEOMETRY_LAYERS) B WHERE SDO_OWNER = SYS_CONTEXT('USERENV'
, 'CURRENT_SCHEMA')