How to view relationships between Primary keys and Foreign keys in your Oracle Database

The following sql statement allows you to view the relationships between primary keys
and foreign keys with other tables.

SELECT uc.constraint_name||CHR(10)
   || '('||ucc1.TABLE_NAME||'.'||ucc1.column_name||')' constraint_source
   , 'REFERENCES'||CHR(10)
   || '('||ucc2.TABLE_NAME||'.'||ucc2.column_name||')' references_column
    FROM user_constraints uc ,
    user_cons_columns ucc1 ,
    user_cons_columns ucc2
    WHERE uc.constraint_name = ucc1.constraint_name
    AND uc.r_constraint_name = ucc2.constraint_name
    and ucc1.position        = ucc2.position
    AND uc.constraint_type   = 'R'
    --AND uc.constraint_name   = 'FKF32F2C126588DBBC'
    order by ucc1.table_name ,
    uc.constraint_name;
 
 
CONSTRAINT_TYPE (from 11gR2 docs)
C - Check constraint on a table
P - Primary key
U - Unique key
R - Referential integrity
V - With check option, on a view
O - With read only, on a view
H - Hash expression
f - constraint that involves a ref column
S - Supplemental logging