Data Dictionary of Oracle 11g



Index | Home | Forums

Table Name Description
ALL_CONS_OBJ_COLUMNS List of types an object column or attribute is constrained to in the tables accessible to the user

Column ID Column name Data type Length Precision NULL Description
1OWNERVARCHAR230(null)YOwner of the table
2TABLE_NAMEVARCHAR230(null)YName of the table containing the object column or attribute
3COLUMN_NAMEVARCHAR24000(null)YFully qualified name of the object column or attribute
4CONS_TYPE_OWNERVARCHAR230(null)YOwner of the type that the column is constrained to
5CONS_TYPE_NAMEVARCHAR230(null)YName of the type that the column is constrained to
6CONS_TYPE_ONLYVARCHAR215(null)YIndication of whether the column is constrained to ONLY type

Index | Home | Forums

This page was created by oracleabc.com on Dec 31,2007 18:49:24
General comments and questions regarding this document should be sent by email to info@oracleabc.com or post your comments here