VIEW: SYS.EXU8ASC

Source

View Text - Preformatted

SELECT  c$.obj#, hh$.obj#, o$.owner#, c$.name, hh$.intcol#,
                hh$.distcnt,
                case when SYS_OP_DV_CHECK(o$.name, o$.owner#) = 1
                     then hh$.lowval
                     else null
                end,
                case when SYS_OP_DV_CHECK(o$.name, o$.owner#) = 1
                     then hh$.hival
                     else null
                end,
                hh$.density, hh$.null_cnt,
                hh$.avgcln, hh$.spare2
        FROM    sys.hist_head$ hh$, sys.obj$ o$, sys.obj$ ot$, sys.col$ c$
        WHERE   hh$.obj# = o$.obj# AND
                c$.obj# = ot$.obj# AND
                o$.owner# = ot$.owner# AND
                hh$.intcol# = c$.intcol#

View Text - HTML Formatted

SELECT C$.OBJ#
, HH$.OBJ#
, O$.OWNER#
, C$.NAME
, HH$.INTCOL#
, HH$.DISTCNT
, CASE WHEN SYS_OP_DV_CHECK(O$.NAME
, O$.OWNER#) = 1 THEN HH$.LOWVAL ELSE NULL END
, CASE WHEN SYS_OP_DV_CHECK(O$.NAME
, O$.OWNER#) = 1 THEN HH$.HIVAL ELSE NULL END
, HH$.DENSITY
, HH$.NULL_CNT
, HH$.AVGCLN
, HH$.SPARE2
FROM SYS.HIST_HEAD$ HH$
, SYS.OBJ$ O$
, SYS.OBJ$ OT$
, SYS.COL$ C$
WHERE HH$.OBJ# = O$.OBJ# AND C$.OBJ# = OT$.OBJ# AND O$.OWNER# = OT$.OWNER# AND HH$.INTCOL# = C$.INTCOL#