select case when bitand(t.property,64)=0
then (select value(b1) from ku$_htable_bytes_alloc_view b1
where b1.obj_num = t.obj#)
else (select value(b2) from ku$_iotable_bytes_alloc_view b2
where b2.obj_num = t.obj#)
end
from tab$ t
SELECT CASE WHEN BITAND(T.PROPERTY
, 64)=0
THEN (SELECT VALUE(B1)
FROM KU$_HTABLE_BYTES_ALLOC_VIEW B1
WHERE B1.OBJ_NUM = T.OBJ#)
ELSE (SELECT VALUE(B2)
FROM KU$_IOTABLE_BYTES_ALLOC_VIEW B2
WHERE B2.OBJ_NUM = T.OBJ#)
END
FROM TAB$ T
|
|
|