VIEW: SYS.EXU8VINFI

Source

View Text - Preformatted

SELECT  vw."VOBJID",vw."VNAME",vw."VTEXT",vw."VOWNER",vw."VOWNERID",vw."VAUDIT",vw."VCOMMENT",vw."VCNAME",vw."PROPERTY",vw."DEFER",vw."FLAGS",vw."OIDLEN",vw."OIDCLAUSE",vw."TYPEOWNER",vw."TYPENAME",vw."VLEN"
        FROM    sys.exu8vinf vw, sys.incexp i, sys.incvid v
        WHERE   i.name(+) = vw.vname AND
                i.owner#(+) = vw.vownerid AND
                v.expid < NVL(i.expid, 9999) AND
                NVL(i.type#, 4) = 4

View Text - HTML Formatted

SELECT VW."VOBJID"
, VW."VNAME"
, VW."VTEXT"
, VW."VOWNER"
, VW."VOWNERID"
, VW."VAUDIT"
, VW."VCOMMENT"
, VW."VCNAME"
, VW."PROPERTY"
, VW."DEFER"
, VW."FLAGS"
, VW."OIDLEN"
, VW."OIDCLAUSE"
, VW."TYPEOWNER"
, VW."TYPENAME"
, VW."VLEN"
FROM SYS.EXU8VINF VW
, SYS.INCEXP I
, SYS.INCVID V
WHERE I.NAME(+) = VW.VNAME AND I.OWNER#(+) = VW.VOWNERID AND V.EXPID < NVL(I.EXPID
, 9999) AND NVL(I.TYPE#
, 4) = 4