1.查询主键(P),外键(R)

select cu.*,au.constraint_type from user_cons_columns cu, user_constraints au where cu.constraint_name = au.constraint_name 
and cu.constraint_name = 'FK_UMOMAPUSER'
and au.constraint_type = 'R'