SQL> SELECT constraint_name, constraint_type, deferrable, 
 2> deferred, validated 
 3> FROM dba_constraints 
 4> WHERE owner = 'HR' AND table_name='EMPLOYEES'; 

 CONSTRAINT_NAME    C    DEFERRABLE        DEFERRED     VALIDATED 
 EMP_DEPT_FK        R    NOT DEFERRABLE    IMMEDIATE    VALIDATED 
 EMP_EMAIL_NV       C    NOT DEFERRABLE    IMMEDIATE    VALIDATED 
 EMP_EMAIL_UK       U    NOT DEFERRABLE    IMMEDIATE    VALIDATED 
 EMP_EMP_ID_PK      P    NOT DEFERRABLE    IMMEDIATE    VALIDATED 
 EMP_HIRE_DATE_NN   C    NOT DEFERRABLE    IMMEDIATE    VALIDATED 
 EMP_JOB_FK         R    NOT DEFERRABLE    IMMEDIATE    VALIDATED 
 EMP_JOB_NN         C    DEFERRABLE        DEFERRED     NOT VALIDATED 
 EMP_LAST_NAME_NN   C    NOT DEFERRABLE    IMMEDIATE    VALIDATED 
 EMP_MANAGER_FK     R    NOT DEFERRABLE    IMMEDIATE    VALIDATED 
 EMP_SALARY_MIN     C    NOT DEFERRABLE    IMMEDIATE    VALIDATED

Show comments for this question (1)
Add comments
Link to this question