VIEW: SYS.KU$_10_1_TABLE_DATA_VIEW

Source

View Text - Preformatted

select t.* from ku$_htable_data_view t
  where refpar_level = 0 and bitand(t.trigflag,65536+131072)=0
  UNION ALL
  select t.* from ku$_htpart_data_view t
  where refpar_level = 0 and bitand(t.trigflag,65536+131072)=0
  UNION ALL
  select t.* from ku$_htspart_data_view t
  where refpar_level = 0 and bitand(t.trigflag,65536+131072)=0
  UNION ALL
  select t.* from ku$_ntable_data_view t
  where refpar_level = 0 and bitand(t.trigflag,65536+131072)=0
  UNION ALL
  select t.* from ku$_eqntable_data_view t
  where bitand(t.trigflag,65536+131072)=0
  UNION ALL
  select t.* from ku$_iotable_data_view t
  where refpar_level = 0 and bitand(t.trigflag,65536+131072)=0
  UNION ALL
  select t.* from ku$_iotpart_data_view t
  where refpar_level = 0 and bitand(t.trigflag,65536+131072)=0

View Text - HTML Formatted

SELECT T.*
FROM KU$_HTABLE_DATA_VIEW T
WHERE REFPAR_LEVEL = 0
AND BITAND(T.TRIGFLAG
, 65536+131072)=0 UNION ALL SELECT T.*
FROM KU$_HTPART_DATA_VIEW T
WHERE REFPAR_LEVEL = 0
AND BITAND(T.TRIGFLAG
, 65536+131072)=0 UNION ALL SELECT T.*
FROM KU$_HTSPART_DATA_VIEW T
WHERE REFPAR_LEVEL = 0
AND BITAND(T.TRIGFLAG
, 65536+131072)=0 UNION ALL SELECT T.*
FROM KU$_NTABLE_DATA_VIEW T
WHERE REFPAR_LEVEL = 0
AND BITAND(T.TRIGFLAG
, 65536+131072)=0 UNION ALL SELECT T.*
FROM KU$_EQNTABLE_DATA_VIEW T
WHERE BITAND(T.TRIGFLAG
, 65536+131072)=0 UNION ALL SELECT T.*
FROM KU$_IOTABLE_DATA_VIEW T
WHERE REFPAR_LEVEL = 0
AND BITAND(T.TRIGFLAG
, 65536+131072)=0 UNION ALL SELECT T.*
FROM KU$_IOTPART_DATA_VIEW T
WHERE REFPAR_LEVEL = 0
AND BITAND(T.TRIGFLAG
, 65536+131072)=0