The DBA_CONSTRAINTS data dictionary view is used to store information of all constraints created on tables and columns by all database users, irrespective of whether they are current or not. The following are some of the columns of the data dictionary view:
| OWNER | VARCHAR2 | It specifies the owner of a constraint. |
| CONSTRAINT_NAME | VARCHAR2 | It specifies the name of a constraint. |
| CONSTRAINT_TYPE | VARCHAR2 | It specifies the type of a constraint. |
| TABLE_NAME | VARCHAR2 | It specifies the name of a table for which a constraint is created. |
| STATUS | VARCHAR2 | It specifies the status of a constraint whether DISABLED or ENABLED. |
| GENERATED | VARCHAR2 | It specifies whether or not a constraint is user or system generated. |
| LAST_CHANGE | DATE | It specifies the date on which a constraint was last updated. |
- Become Oracle OCA DBA 10g certified.
- Pass Oracle oca-dba-11g - OCA DBA 11g
- Pass OCA DBA 9i in first attampt.
- Get certified in first attempt download oca-pl-sql - OCA PL/SQL Developer simulation.
- Pass Oracle ocp-dba10g - OCP DBA 10g
- Become Oracle OCP DBA 11g certified.
- Download free practice test for ocp-dba9i OCP DBA 9i exam.
- Click here to get free ocp-pl-sql OCP PL/SQL Developer exam practice questions.
- Download free practice test for Oracle Oracle Certified Master 10g exam.
- Click here to download oracle-pl-sql test study guide and practice question.
- Best exam simulation Oracle performance-tuning-certified-expert-11g download free trial.
- Become Oracle RAC Certified Expert 10g certified.
- Pass SQL Certified Expert 10g in first attampt.
- Download practice question and study guide for sql-certified-expert-11g for exam.
- Download practice question and study guide for 1Z0-042 for exam.
- Click here to download 1Z0-047 test study guide and practice question.
- Become Oracle OCA: Oracle Database 11g-SQL Fundamentals-I certified.
Like this article? Share it with others
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
