OWNER | |
CONSTRAINT_NAME | |
CONSTRAINT_TYPE | P: primary key, R: foreign key, U: unique key, C: check constraint, V: with check option (on views), O: with read only (on views), H: hash expression, F: ref expression constraint, S: supplemental logging |
TABLE_NAME | |
SEARCH_CONDITION, SEARCH_CONDITION_VC | The condition of a check constraint as long and varchar2(4000). |
R_OWNER, R_CONSTRAINT_NAME | For foreign keys: identification of the primary or unique key constraint that the foreign key references |
DELETE_RULE | |
STATUS | ENABLED or DISABLED |
DEFERRABLE | DEFERRABLE or NOT DEFERRABLE |
DEFERRED | DEFERRED or IMMEDIATE |
VALIDATED | VALIDATED or NOT VALIDATED. Meaning depends on value of STATUS. |
GENERATED | The value is either USER NAME or GENERATED NAME and indicates whether the name of the constraints was provided when the constraint was created: If the value is GENERATED NAME, the constraint name was chosen by Oracle and starts with SYS_. |
BAD | BAD or null |
RELY | |
LAST_CHANGE | |
INDEX_OWNER, INDEX_NAME | Identification of used index. |
INVALID | |
VIEW_RELATED | DEPEND ON VIEW or null |
ORIGIN_CON_ID | |