--查询 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‘);
查询表与之相关联的子表
原文：http://www.cnblogs.com/ocean-san/p/4585316.html
