sql获取表间关联

select a.TABLE_NAME, b.table_name, a.CONSTRAINT_NAME
  from user_constraints a, user_constraints b
 where (a.CONSTRAINT_NAME = b.r_constraint_name
   and a.CONSTRAINT_TYPE = 'P'
   AND b.constraint_type = 'R') order by a.table_name