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
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
|
|
|