VIEW: SYS.EXU8DIMI

Source

View Text - Preformatted

SELECT  dm."OWNERID",dm."OWNER",dm."DIMNAME",dm."DIMTEXT"
        FROM    sys.exu8dim dm, sys.incexp i, sys.incvid v
        WHERE   dm.dimname = i.name(+) AND
                dm.ownerid = i.owner#(+) AND
                NVL(i.type#, 43) = 43 AND
                v.expid < NVL(i.expid, 9999)

View Text - HTML Formatted

SELECT DM."OWNERID"
, DM."OWNER"
, DM."DIMNAME"
, DM."DIMTEXT"
FROM SYS.EXU8DIM DM
, SYS.INCEXP I
, SYS.INCVID V
WHERE DM.DIMNAME = I.NAME(+) AND DM.OWNERID = I.OWNER#(+) AND NVL(I.TYPE#
, 43) = 43 AND V.EXPID < NVL(I.EXPID
, 9999)