Search notes:

Column constraint_type (DBA_CONSTRAINTS, ALL_CONSTRAINTS, USER_CONSTRAINTS)

select
  -- count(*),
  constraint_type
from
  dba_constraints
group by
  constraint_type
order by
  count(*) desc;
-- C
-- P
-- R
-- O
-- U
-- F
-- V  
Github repository oracle-patterns, path: /Installed/data-dictionary/constraints/constraint_type.sql
The constraint type is a one letter flag which is one of (as of 12cR1):

See also

dba_constraints
Table constraints
Primary-foreign key related data might be stored in a cluster.

Index