SELECT SDO_OWNER OWNER, NAME, DESCRIPTION, BASE_TABLE,
GEOMETRY_COLUMN, STYLING_RULES
FROM SDO_THEMES_TABLE
WHERE
(exists
(select table_name from all_tables
where table_name=base_table
and owner = sdo_owner
union all
select table_name from all_object_tables
where table_name=base_table
and owner = sdo_owner
union all
select view_name table_name from all_views
where view_name=base_table
and owner = sdo_owner))
SELECT SDO_OWNER OWNER
, NAME
, DESCRIPTION
, BASE_TABLE
,
GEOMETRY_COLUMN
, STYLING_RULES
FROM SDO_THEMES_TABLE
WHERE
(EXISTS
(SELECT TABLE_NAME
FROM ALL_TABLES
WHERE TABLE_NAME=BASE_TABLE
AND OWNER = SDO_OWNER
UNION ALL
SELECT TABLE_NAME
FROM ALL_OBJECT_TABLES
WHERE TABLE_NAME=BASE_TABLE
AND OWNER = SDO_OWNER
UNION ALL
SELECT VIEW_NAME TABLE_NAME
FROM ALL_VIEWS
WHERE VIEW_NAME=BASE_TABLE
AND OWNER = SDO_OWNER))
|
|
|