VIEW: SYS.KU$_10_1_HISTGRM_MAX_VIEW

Source

View Text - Preformatted

select  hh.obj#, hh.intcol#, 1,
           case when SYS_OP_DV_CHECK(o.name, o.owner#) = 1
                then hh.maximum
                else null
           end,
           NULL, NULL, 0, NULL
   from    sys.obj$ o, sys.hist_head$ hh
   where   bucket_cnt = 1 AND o.obj# = hh.obj#

View Text - HTML Formatted

SELECT HH.OBJ#
, HH.INTCOL#
, 1
, CASE WHEN SYS_OP_DV_CHECK(O.NAME
, O.OWNER#) = 1 THEN HH.MAXIMUM ELSE NULL END
, NULL
, NULL
, 0
, NULL
FROM SYS.OBJ$ O
, SYS.HIST_HEAD$ HH
WHERE BUCKET_CNT = 1
AND O.OBJ# = HH.OBJ#