VIEW: MDSYS.USER_SDO_THEMES

Source

View Text - Preformatted

SELECT NAME, DESCRIPTION, BASE_TABLE, GEOMETRY_COLUMN, STYLING_RULES
FROM SDO_THEMES_TABLE
WHERE sdo_owner = sys_context('userenv', 'CURRENT_SCHEMA')

View Text - HTML Formatted

SELECT NAME
, DESCRIPTION
, BASE_TABLE
, GEOMETRY_COLUMN
, STYLING_RULES FROM SDO_THEMES_TABLE WHERE SDO_OWNER = SYS_CONTEXT('USERENV'
, 'CURRENT_SCHEMA')