查询表与之相关联的子表

--查询
select a.*
  from user_constraints a
 where a.CONSTRAINT_TYPE = 'R'
   and a.R_CONSTRAINT_NAME in
       (select b.CONSTRAINT_NAME
          from user_constraints b
         where b.TABLE_NAME = 'your_table_name');