VIEW: SYS.EXU8SPRI

Source

View Text - Preformatted

SELECT  s."OWNERID",s."UNAME",s."ID",s."NAME",s."TIME",s."TYPEID",s."TYPE",s."AUDT",s."SQLVER"
        FROM    sys.exu8spr s, sys.incexp i, sys.incvid v
        WHERE   s.name = i.name(+) AND
                s.ownerid = i.owner#(+) AND
                NVL(i.type#, 7) IN (7, 8, 9, 11) AND
                NVL(i.expid, 9999) > v.expid

View Text - HTML Formatted

SELECT S."OWNERID"
, S."UNAME"
, S."ID"
, S."NAME"
, S."TIME"
, S."TYPEID"
, S."TYPE"
, S."AUDT"
, S."SQLVER"
FROM SYS.EXU8SPR S
, SYS.INCEXP I
, SYS.INCVID V
WHERE S.NAME = I.NAME(+) AND S.OWNERID = I.OWNER#(+) AND NVL(I.TYPE#
, 7) IN (7
, 8
, 9
, 11) AND NVL(I.EXPID
, 9999) > V.EXPID