VIEW: MDSYS.ALL_SDO_TOPO_METADATA

Source

View Text - Preformatted

SELECT SDO_OWNER OWNER,
       Topology,
       Topology_id,
       Tolerance,
       SRID,
       b.owner Table_owner,
       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,
       Topology||'_NODE_S' Node_Sequence,
       Topology||'_EDGE_S' Edge_Sequence,
       Topology||'_FACE_S' Face_Sequence,
       Topology||'_TG_S' TG_Sequence,
       Digits_Right_Of_Decimal
FROM SDO_TOPO_METADATA_TABLE a,
     TABLE (a.Topo_Geometry_Layers) b
WHERE
(exists
   (select table_name from all_tables
    where table_name=topology || '_NODE$'
      and owner = sdo_owner
    union all
    select view_name from all_views
    where  view_name=topology || '_NODE$'
      and owner = sdo_owner))

View Text - HTML Formatted

SELECT SDO_OWNER OWNER
, TOPOLOGY
, TOPOLOGY_ID
, TOLERANCE
, SRID
, B.OWNER TABLE_OWNER
, 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
, TOPOLOGY||'_NODE_S' NODE_SEQUENCE
, TOPOLOGY||'_EDGE_S' EDGE_SEQUENCE
, TOPOLOGY||'_FACE_S' FACE_SEQUENCE
, TOPOLOGY||'_TG_S' TG_SEQUENCE
, DIGITS_RIGHT_OF_DECIMAL FROM SDO_TOPO_METADATA_TABLE A
, TABLE (A.TOPO_GEOMETRY_LAYERS) B WHERE (EXISTS (SELECT TABLE_NAME
FROM ALL_TABLES
WHERE TABLE_NAME=TOPOLOGY || '_NODE$'
AND OWNER = SDO_OWNER UNION ALL SELECT VIEW_NAME
FROM ALL_VIEWS
WHERE VIEW_NAME=TOPOLOGY || '_NODE$'
AND OWNER = SDO_OWNER))