VIEW: SYS.KU$_10_1_HISTGRM_MIN_VIEW

Source

View Text - Preformatted

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

View Text - HTML Formatted

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