VIEW: MDSYS.ALL_SDO_3DTHEMES

Source

View Text - Preformatted

SELECT SDO_OWNER OWNER, NAME, DESCRIPTION, BASE_TABLE,
                  THEME_COLUMN, STYLE_COLUMN, THEME_TYPE, DEFINITION
FROM SDO_3DTHEMES_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))

View Text - HTML Formatted

SELECT SDO_OWNER OWNER
, NAME
, DESCRIPTION
, BASE_TABLE
, THEME_COLUMN
, STYLE_COLUMN
, THEME_TYPE
, DEFINITION FROM SDO_3DTHEMES_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))