Вывести имена и типы ограничений, а также условия проверки для ограничения CHECK и имена ссылочных ограничений.
SQL> SELECT constraint_name, constraint_type,
2 search_condition, r_constraint_name
3 FROM user_constraints;
CONSTRAINT_NAME C SEARCH_CONDITION R_CONSTRAINT_NAME
-------------------- - ------------------------- --------------------
E_L_NN C "LAST_NAME" IS NOT NULL
E_F_NN C "FIRST_NAME" IS NOT NULL
E_PK P
E_M_FK R E_PK
E_P_PK P
E_P_ID_EMP_FK R E_PK
E_P_ID_PR_FK R P_PK
P_NAME_NN C "NAME" IS NOT NULL
P_PK P
SP_NAME_NN C "NAME" IS NOT NULL
SP_PK P
SP_ID_P_FK R P_PK
12 rows selected.