DBA Data[Home] [Help]

VIEW: SYS.KU$_JIJOIN_TABLE_VIEW

Source

View Text - Preformatted

select j.obj#, o.obj_num, o.owner_name, o.name
  from sys.ku$_schemaobj_view o, sys.jijoin$ j
  where o.obj_num in (j.tab1obj#, j.tab2obj#)
  group by j.obj#, o.obj_num, o.owner_name, o.name
  order by o.obj_num
View Text - HTML Formatted

SELECT J.OBJ#
, O.OBJ_NUM
, O.OWNER_NAME
, O.NAME
FROM SYS.KU$_SCHEMAOBJ_VIEW O
, SYS.JIJOIN$ J
WHERE O.OBJ_NUM IN (J.TAB1OBJ#
, J.TAB2OBJ#) GROUP BY J.OBJ#
, O.OBJ_NUM
, O.OWNER_NAME
, O.NAME ORDER BY O.OBJ_NUM