constraint ---OCP--047--259

SQL> desc user_constraints
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 OWNER                                              VARCHAR2(30)
 CONSTRAINT_NAME                           NOT NULL VARCHAR2(30)
 CONSTRAINT_TYPE ---约束类型                         VARCHAR2(1)
 TABLE_NAME      ---表名                    NOT NULL VARCHAR2(30)
 SEARCH_CONDITION                                   LONG
 R_OWNER                                            VARCHAR2(30)
 R_CONSTRAINT_NAME                                  VARCHAR2(30)
 DELETE_RULE                                        VARCHAR2(9)
 STATUS    ---约束状态，是否in use                    VARCHAR2(8)
 DEFERRABLE                                         VARCHAR2(14)
 DEFERRED                                           VARCHAR2(9)
 VALIDATED                                          VARCHAR2(13)
 GENERATED                                          VARCHAR2(14)
 BAD                                                VARCHAR2(3)
 RELY                                               VARCHAR2(4)
 LAST_CHANGE                                        DATE
 INDEX_OWNER                                        VARCHAR2(30)
 INDEX_NAME                                         VARCHAR2(30)
 INVALID                                            VARCHAR2(7)
 VIEW_RELATED                                       VARCHAR2(14)

 

SQL> col CONSTRAINT_NAME for a35
SQL> col SEARCH_CONDITION for a35
SQL> select constraint_name,constraint_type,search_condition,r_constraint_name,delete_rule,status
from user_constraints;

ORACLE约束类型：
PRIMARY KEY   主键
UNIQUE KEY    唯一键
FOREIGN KEY  外键
NOT NULL       非空
CHECK键

 

转载于:https://www.cnblogs.com/Peyton-for-2012/archive/2013/01/18/2866452.html