VIEW: SYS.KU$_10_1_TABLE_OBJNUM_VIEW

Source

View Text - Preformatted

select t.* from ku$_11_2_table_objnum_view t
    where
     NOT EXISTS (
       select property from col$ c /* exclude tabs with virtual cols */
       where c.obj# = t.obj_num
           and bitand(c.property, 65536) >= 65536            /* virtual cols */
           and bitand(c.property, 256) = 0               /* not a sysgen col */
           and bitand(c.property, 32768) = 0)                  /* not unused */

View Text - HTML Formatted

SELECT T.*
FROM KU$_11_2_TABLE_OBJNUM_VIEW T WHERE NOT EXISTS ( SELECT PROPERTY
FROM COL$ C /* EXCLUDE TABS WITH VIRTUAL COLS */
WHERE C.OBJ# = T.OBJ_NUM
AND BITAND(C.PROPERTY
, 65536) >= 65536 /* VIRTUAL COLS */
AND BITAND(C.PROPERTY
, 256) = 0 /* NOT A SYSGEN COL */
AND BITAND(C.PROPERTY
, 32768) = 0) /* NOT UNUSED */