select r.TABLE_NAME
from USER_CONSTRAINTS p, USER_CONSTRAINTS r
where p.TABLE_NAME = 'TABLENAME'
and r.CONSTRAINT_TYPE = 'R'
and p.CONSTRAINT_NAME = r.R_CONSTRAINT_NAME
将TABLENAME换成真实的表名,即可查看这张表的主键被哪些表引用了
select r.TABLE_NAME
from USER_CONSTRAINTS p, USER_CONSTRAINTS r
where p.TABLE_NAME = 'TABLENAME'
and r.CONSTRAINT_TYPE = 'R'
and p.CONSTRAINT_NAME = r.R_CONSTRAINT_NAME
将TABLENAME换成真实的表名,即可查看这张表的主键被哪些表引用了