VIEW: SYS.USER_DIM_ATTRIBUTES

Source

View Text - Preformatted

select u.name, o.name, da.attname, dl.levelname, c.name, 'N'
from sys.dimattr$ da, sys.obj$ o, sys.user$ u, sys.dimlevel$ dl, sys.col$ c
where da.dimobj# = o.obj#
  and o.owner# = u.user#
  and da.dimobj# = dl.dimobj#
  and da.levelid# = dl.levelid#
  and da.detailobj# = c.obj#
  and da.col# = c.intcol#
  and o.owner# = userenv('SCHEMAID')

View Text - HTML Formatted

SELECT U.NAME
, O.NAME
, DA.ATTNAME
, DL.LEVELNAME
, C.NAME
, 'N' FROM SYS.DIMATTR$ DA
, SYS.OBJ$ O
, SYS.USER$ U
, SYS.DIMLEVEL$ DL
, SYS.COL$ C WHERE DA.DIMOBJ# = O.OBJ#
AND O.OWNER# = U.USER#
AND DA.DIMOBJ# = DL.DIMOBJ#
AND DA.LEVELID# = DL.LEVELID#
AND DA.DETAILOBJ# = C.OBJ#
AND DA.COL# = C.INTCOL#
AND O.OWNER# = USERENV('SCHEMAID')