VIEW: SYS.EXU10ASC

Source

View Text - Preformatted

SELECT  c$.obj#, hh$.obj#, o$.owner#, REPLACE(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, c$.property
        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#
, REPLACE(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
, C$.PROPERTY
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#