DBA_CONS_COLUMNS view tips

Oracle Tips by Burleson Consulting

DBA_CONS_COLUMNS

<< Return to the index

Oracle 11g makes the following comments about the DBA_CONS_COLUMNS table: "Information about accessible columns in constraint definitions"

Related notes on DBA_CONS_COLUMNS:

Column description of the DBA_CONS_COLUMNS view:

OWNER

Description of DBA_CONS_COLUMNS.OWNER: "Owner of the constraint definition"

CONSTRAINT_NAME

Description of DBA_CONS_COLUMNS.CONSTRAINT_NAME: "Name associated with the constraint definition"

TABLE_NAME

Description of DBA_CONS_COLUMNS.TABLE_NAME: "Name associated with table with constraint definition"

COLUMN_NAME

Description of DBA_CONS_COLUMNS.COLUMN_NAME: "Name associated with column or attribute of object column specified in the constraint definition"

POSITION

Description of DBA_CONS_COLUMNS.POSITION: "Original position of column or attribute in definition"

DBA_CONS_COLUMNS View Source

Oracle 11g's data dictionary defines the DBA_CONS_COLUMNS view using the following source query:

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# != 12 /* don't include log groups */
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#(+)

If you like Oracle tuning, see the book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts.
You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.

Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA

Oracle performance Tuning 10g reference poster

Oracle training & performance tuning books