VIEW: SYS.EXU8HST

Source

View Text - Preformatted

SELECT  h$.obj#, o$.owner#, h$.intcol#, h$.bucket,
                case when SYS_OP_DV_CHECK(o$.name, o$.owner#) = 1
                     then h$.endpoint
                     else null
                end,
                case when SYS_OP_DV_CHECK(o$.name, o$.owner#) = 1
                     then h$.epvalue
                     else null
                end
        FROM    sys.histgrm$ h$, sys.obj$ o$
        WHERE   h$.obj# = o$.obj#
      UNION ALL
        SELECT  h$.obj#, o$.owner#, h$.intcol#, 0,
                case when SYS_OP_DV_CHECK(o$.name, o$.owner#) = 1
                     then h$.minimum
                     else null
                end,
                NULL
        FROM    sys.hist_head$ h$, sys.obj$ o$
        WHERE   h$.obj# = o$.obj# AND
                h$.bucket_cnt = 1
      UNION ALL
        SELECT  h$.obj#, o$.owner#, h$.intcol#, 1,
                case when SYS_OP_DV_CHECK(o$.name, o$.owner#) = 1
                     then h$.maximum
                     else null
                end,
                NULL
        FROM    sys.hist_head$ h$, sys.obj$ o$
        WHERE   h$.obj# = o$.obj# AND
                h$.bucket_cnt = 1

View Text - HTML Formatted

SELECT H$.OBJ#
, O$.OWNER#
, H$.INTCOL#
, H$.BUCKET
, CASE WHEN SYS_OP_DV_CHECK(O$.NAME
, O$.OWNER#) = 1 THEN H$.ENDPOINT ELSE NULL END
, CASE WHEN SYS_OP_DV_CHECK(O$.NAME
, O$.OWNER#) = 1 THEN H$.EPVALUE ELSE NULL END
FROM SYS.HISTGRM$ H$
, SYS.OBJ$ O$
WHERE H$.OBJ# = O$.OBJ# UNION ALL SELECT H$.OBJ#
, O$.OWNER#
, H$.INTCOL#
, 0
, CASE WHEN SYS_OP_DV_CHECK(O$.NAME
, O$.OWNER#) = 1 THEN H$.MINIMUM ELSE NULL END
, NULL
FROM SYS.HIST_HEAD$ H$
, SYS.OBJ$ O$
WHERE H$.OBJ# = O$.OBJ# AND H$.BUCKET_CNT = 1 UNION ALL SELECT H$.OBJ#
, O$.OWNER#
, H$.INTCOL#
, 1
, CASE WHEN SYS_OP_DV_CHECK(O$.NAME
, O$.OWNER#) = 1 THEN H$.MAXIMUM ELSE NULL END
, NULL
FROM SYS.HIST_HEAD$ H$
, SYS.OBJ$ O$
WHERE H$.OBJ# = O$.OBJ# AND H$.BUCKET_CNT = 1