VIEW: SYS.KU$_M_VIEW_VIEW

Source

View Text - Preformatted

select * from ku$_m_view_view_base b
  where  bitand(b.flag2,33554432) != 33554432
    and (bitand(b.flag3, 512) = 0                /* snapshot != zonemap */
     or bitand(b.xpflags, 34359738368) = 0)      /* summary != zonemap */
    and ((b.unusablebef_num = 0 OR
         dbms_editions_utilities.compare_edition(
           dbms_metadata.get_edition_id,
           b.unusablebef_num) in (0, 2))
         AND
         (b.unusablebeg_num = 0 OR
          dbms_editions_utilities.compare_edition(
            dbms_metadata.get_edition_id,
            b.unusablebeg_num) = 1))

View Text - HTML Formatted

SELECT *
FROM KU$_M_VIEW_VIEW_BASE B
WHERE BITAND(B.FLAG2
, 33554432) != 33554432
AND (BITAND(B.FLAG3
, 512) = 0 /* SNAPSHOT != ZONEMAP */ OR BITAND(B.XPFLAGS
, 34359738368) = 0) /* SUMMARY != ZONEMAP */
AND ((B.UNUSABLEBEF_NUM = 0 OR DBMS_EDITIONS_UTILITIES.COMPARE_EDITION( DBMS_METADATA.GET_EDITION_ID
, B.UNUSABLEBEF_NUM) IN (0
, 2)) AND (B.UNUSABLEBEG_NUM = 0 OR DBMS_EDITIONS_UTILITIES.COMPARE_EDITION( DBMS_METADATA.GET_EDITION_ID
, B.UNUSABLEBEG_NUM) = 1))