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))
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))
|
|
|