VIEW: SYS.EXU8VNC

Source

View Text - Preformatted

SELECT  "VOBJID","VNAME","VTEXT","VOWNER","VOWNERID","VAUDIT","VCOMMENT","VCNAME","PROPERTY","DEFER","FLAGS","OIDLEN","OIDCLAUSE","TYPEOWNER","TYPENAME","VLEN"
        FROM    sys.exu8vinf vf$
        WHERE   NOT EXISTS (
                    SELECT  0
                    FROM    sys.exu8vdpt vd$
                    WHERE   vd$.parent = vf$.vobjid)

View Text - HTML Formatted

SELECT "VOBJID"
, "VNAME"
, "VTEXT"
, "VOWNER"
, "VOWNERID"
, "VAUDIT"
, "VCOMMENT"
, "VCNAME"
, "PROPERTY"
, "DEFER"
, "FLAGS"
, "OIDLEN"
, "OIDCLAUSE"
, "TYPEOWNER"
, "TYPENAME"
, "VLEN"
FROM SYS.EXU8VINF VF$
WHERE NOT EXISTS ( SELECT 0
FROM SYS.EXU8VDPT VD$
WHERE VD$.PARENT = VF$.VOBJID)