VIEW: SYS.DBA_JOIN_IND_COLUMNS

Source

View Text - Preformatted

select
  ui.name, oi.name,
  uti.name, oti.name, ci.name,
  uto.name, oto.name, co.name
from
  sys.user$ ui, sys.user$ uti, sys.user$ uto,
  sys.obj$ oi, sys.obj$ oti, sys.obj$ oto,
  sys.col$ ci, sys.col$ co,
  sys.jijoin$ ji
where ji.obj# = oi.obj#
  and oi.owner# = ui.user#
  and ji.tab1obj# = oti.obj#
  and oti.owner# = uti.user#
  and ci.obj# = oti.obj#
  and ji.tab1col# = ci.intcol#
  and ji.tab2obj# = oto.obj#
  and oto.owner# = uto.user#
  and co.obj# = oto.obj#
  and ji.tab2col# = co.intcol#

View Text - HTML Formatted

SELECT UI.NAME
, OI.NAME
, UTI.NAME
, OTI.NAME
, CI.NAME
, UTO.NAME
, OTO.NAME
, CO.NAME FROM SYS.USER$ UI
, SYS.USER$ UTI
, SYS.USER$ UTO
, SYS.OBJ$ OI
, SYS.OBJ$ OTI
, SYS.OBJ$ OTO
, SYS.COL$ CI
, SYS.COL$ CO
, SYS.JIJOIN$ JI WHERE JI.OBJ# = OI.OBJ#
AND OI.OWNER# = UI.USER#
AND JI.TAB1OBJ# = OTI.OBJ#
AND OTI.OWNER# = UTI.USER#
AND CI.OBJ# = OTI.OBJ#
AND JI.TAB1COL# = CI.INTCOL#
AND JI.TAB2OBJ# = OTO.OBJ#
AND OTO.OWNER# = UTO.USER#
AND CO.OBJ# = OTO.OBJ#
AND JI.TAB2COL# = CO.INTCOL#