VIEW: SYS.EXU8VEW

Source

View Text - Preformatted

SELECT  o$.obj#, o$.name, v$.text, u$.name, o$.owner#, v$.audit$,
                com$.comment$, c$.name, d$.dlevel, v$.property,
                NVL(cd$.defer, 0), NVL(o$.flags, 0), NVL(vt$.oidtextlength, 0),
                vt$.oidtext, vt$.typeowner, vt$.typename, v$.textlength,
                sv$.sql_version, NVL(vt$.undertextlength, 0), vt$.undertext
        FROM    sys.exu81obj o$, sys.view$ v$, sys.user$ u$, sys.cdef$ cd$,
                sys.con$ c$, sys.com$ com$, sys.exu8ord d$,
                sys.typed_view$ vt$, sys.exu816sqv sv$
        WHERE   v$.obj# = o$.obj# AND
                o$.owner# = u$.user# AND
                o$.obj# = cd$.obj#(+) AND
                cd$.con# = c$.con#(+) AND
                o$.obj# = com$.obj#(+) AND
                com$.col#(+) IS NULL AND
                o$.obj# = d$.obj#(+) AND
                v$.obj# = vt$.obj# (+) AND
                o$.spare1 = sv$.version# (+)

View Text - HTML Formatted

SELECT O$.OBJ#
, O$.NAME
, V$.TEXT
, U$.NAME
, O$.OWNER#
, V$.AUDIT$
, COM$.COMMENT$
, C$.NAME
, D$.DLEVEL
, V$.PROPERTY
, NVL(CD$.DEFER
, 0)
, NVL(O$.FLAGS
, 0)
, NVL(VT$.OIDTEXTLENGTH
, 0)
, VT$.OIDTEXT
, VT$.TYPEOWNER
, VT$.TYPENAME
, V$.TEXTLENGTH
, SV$.SQL_VERSION
, NVL(VT$.UNDERTEXTLENGTH
, 0)
, VT$.UNDERTEXT
FROM SYS.EXU81OBJ O$
, SYS.VIEW$ V$
, SYS.USER$ U$
, SYS.CDEF$ CD$
, SYS.CON$ C$
, SYS.COM$ COM$
, SYS.EXU8ORD D$
, SYS.TYPED_VIEW$ VT$
, SYS.EXU816SQV SV$
WHERE V$.OBJ# = O$.OBJ# AND O$.OWNER# = U$.USER# AND O$.OBJ# = CD$.OBJ#(+) AND CD$.CON# = C$.CON#(+) AND O$.OBJ# = COM$.OBJ#(+) AND COM$.COL#(+) IS NULL AND O$.OBJ# = D$.OBJ#(+) AND V$.OBJ# = VT$.OBJ# (+) AND O$.SPARE1 = SV$.VERSION# (+)