VIEW: MDSYS.DBA_SDO_THEMES

Source

View Text - Preformatted

SELECT SDO_OWNER OWNER, NAME, DESCRIPTION, BASE_TABLE,
              GEOMETRY_COLUMN, STYLING_RULES
FROM SDO_THEMES_TABLE
WHERE
(exists
   (select table_name from dba_tables
    where table_name=base_table
    union all
      select table_name from dba_object_tables
      where table_name=base_table
    union all
    select view_name table_name from dba_views
    where  view_name=base_table))

View Text - HTML Formatted

SELECT SDO_OWNER OWNER
, NAME
, DESCRIPTION
, BASE_TABLE
, GEOMETRY_COLUMN
, STYLING_RULES FROM SDO_THEMES_TABLE WHERE (EXISTS (SELECT TABLE_NAME
FROM DBA_TABLES
WHERE TABLE_NAME=BASE_TABLE UNION ALL SELECT TABLE_NAME
FROM DBA_OBJECT_TABLES
WHERE TABLE_NAME=BASE_TABLE UNION ALL SELECT VIEW_NAME TABLE_NAME
FROM DBA_VIEWS
WHERE VIEW_NAME=BASE_TABLE))