VIEW: SYS.EXU7SNAPI

Source

View Text - Preformatted

SELECT s."OWNER",s."OWNERID",s."NAME",s."TABLE_NAME",s."MASTER_VIEW",s."MASTER_OWNER",s."MASTER",s."MASTER_LINK",s."CAN_USE_LOG",s."LAST_REFRESH",s."ERROR",s."TYPE",s."NEXT",s."START_WITH",s."QUERY",s."UPDATABLE",s."UPDATE_TRIG",s."UPDATE_LOG" from exu7snap s,incexp i, incvid v
       WHERE s.name  = i.name(+) AND s.ownerid = i.owner#(+) AND
             NVL(i.type#,-2) = -2 AND
             NVL(i.expid,9999) > v.expid

View Text - HTML Formatted

SELECT S."OWNER"
, S."OWNERID"
, S."NAME"
, S."TABLE_NAME"
, S."MASTER_VIEW"
, S."MASTER_OWNER"
, S."MASTER"
, S."MASTER_LINK"
, S."CAN_USE_LOG"
, S."LAST_REFRESH"
, S."ERROR"
, S."TYPE"
, S."NEXT"
, S."START_WITH"
, S."QUERY"
, S."UPDATABLE"
, S."UPDATE_TRIG"
, S."UPDATE_LOG"
FROM EXU7SNAP S
, INCEXP I
, INCVID V
WHERE S.NAME = I.NAME(+)
AND S.OWNERID = I.OWNER#(+) AND NVL(I.TYPE#
, -2) = -2 AND NVL(I.EXPID
, 9999) > V.EXPID