VIEW: SYS.EXU7SYNI

Source

View Text - Preformatted

SELECT s."SYNNAM",s."SYNTAB",s."TABOWN",s."TABNODE",s."PUBLIC$",s."SYNOWN",s."SYNOWNID",s."SYNTIME" from exu7syn s, incexp i, incvid v
       WHERE s.synnam = i.name(+) AND s.synownid = i.owner#(+) AND 
             NVL(i.type#,5) = 5 AND NVL(i.expid,9999) > v.expid

View Text - HTML Formatted

SELECT S."SYNNAM"
, S."SYNTAB"
, S."TABOWN"
, S."TABNODE"
, S."PUBLIC$"
, S."SYNOWN"
, S."SYNOWNID"
, S."SYNTIME"
FROM EXU7SYN S
, INCEXP I
, INCVID V
WHERE S.SYNNAM = I.NAME(+)
AND S.SYNOWNID = I.OWNER#(+)
AND NVL(I.TYPE#
, 5) = 5
AND NVL(I.EXPID
, 9999) > V.EXPID