VIEW: MDSYS.USER_SDO_LRS_METADATA

Source

View Text - Preformatted

SELECT  SDO_TABLE_NAME  TABLE_NAME,
        SDO_COLUMN_NAME COLUMN_NAME,
        SDO_DIM_POS     DIM_POS,
        SDO_DIM_UNIT    DIM_UNIT
FROM SDO_LRS_METADATA_TABLE,
     (select sys_context('userenv', 'CURRENT_USER') username from dual)
WHERE  sdo_owner = username

View Text - HTML Formatted

SELECT SDO_TABLE_NAME TABLE_NAME
, SDO_COLUMN_NAME COLUMN_NAME
, SDO_DIM_POS DIM_POS
, SDO_DIM_UNIT DIM_UNIT FROM SDO_LRS_METADATA_TABLE
, (SELECT SYS_CONTEXT('USERENV'
, 'CURRENT_USER') USERNAME
FROM DUAL) WHERE SDO_OWNER = USERNAME