oracle查寻表约束

oracle查找表约束
SELECT constraint_name, table_name, r_owner, r_constraint_name

FROM all_constraints

WHERE table_name = 'table_name' and owner = 'owner_name';