VIEW: SYS.DBA_CONS_COLUMNS

Source

View Text - Preformatted

select u.name, c.name, o.name,
       decode(ac.name, null, col.name, ac.name), cc.pos#
from sys.user$ u, sys.con$ c, sys.col$ col, sys.ccol$ cc, sys.cdef$ cd,
     sys."_CURRENT_EDITION_OBJ" o, sys.attrcol$ ac
where c.owner# = u.user#
  and c.con# = cd.con#
  and (cd.type# < 14 or cd.type# > 17)   /* don't include supplog cons   */
  and (cd.type# != 12)                   /* don't include log group cons */
  and cd.con# = cc.con#
  and cc.obj# = col.obj#
  and cc.intcol# = col.intcol#
  and cc.obj# = o.obj#
  and col.obj# = ac.obj#(+)
  and col.intcol# = ac.intcol#(+)

View Text - HTML Formatted

SELECT U.NAME
, C.NAME
, O.NAME
, DECODE(AC.NAME
, NULL
, COL.NAME
, AC.NAME)
, CC.POS# FROM SYS.USER$ U
, SYS.CON$ C
, SYS.COL$ COL
, SYS.CCOL$ CC
, SYS.CDEF$ CD
, SYS."_CURRENT_EDITION_OBJ" O
, SYS.ATTRCOL$ AC WHERE C.OWNER# = U.USER#
AND C.CON# = CD.CON#
AND (CD.TYPE# < 14 OR CD.TYPE# > 17) /* DON'T INCLUDE SUPPLOG CONS */
AND (CD.TYPE# != 12) /* DON'T INCLUDE LOG GROUP CONS */
AND CD.CON# = CC.CON#
AND CC.OBJ# = COL.OBJ#
AND CC.INTCOL# = COL.INTCOL#
AND CC.OBJ# = O.OBJ#
AND COL.OBJ# = AC.OBJ#(+)
AND COL.INTCOL# = AC.INTCOL#(+)