[Home] [Help]
VIEW: MDSYS.USER_SDO_GEOM_METADATA
Source
View Text - Preformatted
SELECT SDO_TABLE_NAME TABLE_NAME,
SDO_COLUMN_NAME COLUMN_NAME,
SDO_DIMINFO DIMINFO,
SDO_SRID SRID
FROM SDO_GEOM_METADATA_TABLE
WHERE sdo_owner = sys_context('userenv', 'CURRENT_USER')
View Text - HTML Formatted
SELECT SDO_TABLE_NAME TABLE_NAME
,
SDO_COLUMN_NAME COLUMN_NAME
,
SDO_DIMINFO DIMINFO
,
SDO_SRID SRID
FROM SDO_GEOM_METADATA_TABLE
WHERE SDO_OWNER = SYS_CONTEXT('USERENV'
, 'CURRENT_USER')