DBA Data[Home] [Help]

VIEW: SYS.KU$_10_2_TABLE_DATA_VIEW

Source

View Text - Preformatted

select t.* from ku$_htable_data_view t
  where refpar_level = 0
  UNION ALL
  select t.* from ku$_htpart_data_view t
  where refpar_level = 0
  UNION ALL
  select t.* from ku$_htspart_data_view t
  where refpar_level = 0
  UNION ALL
  select t.* from ku$_ntable_data_view t
  where refpar_level = 0
  UNION ALL
  select * from ku$_eqntable_data_view
  UNION ALL
  select t.* from ku$_iotable_data_view t
  where refpar_level = 0
  UNION ALL
  select t.* from ku$_iotpart_data_view t
  where refpar_level = 0
View Text - HTML Formatted

SELECT T.*
FROM KU$_HTABLE_DATA_VIEW T
WHERE REFPAR_LEVEL = 0 UNION ALL SELECT T.*
FROM KU$_HTPART_DATA_VIEW T
WHERE REFPAR_LEVEL = 0 UNION ALL SELECT T.*
FROM KU$_HTSPART_DATA_VIEW T
WHERE REFPAR_LEVEL = 0 UNION ALL SELECT T.*
FROM KU$_NTABLE_DATA_VIEW T
WHERE REFPAR_LEVEL = 0 UNION ALL SELECT *
FROM KU$_EQNTABLE_DATA_VIEW UNION ALL SELECT T.*
FROM KU$_IOTABLE_DATA_VIEW T
WHERE REFPAR_LEVEL = 0 UNION ALL SELECT T.*
FROM KU$_IOTPART_DATA_VIEW T
WHERE REFPAR_LEVEL = 0