oracle 中查询某表的主外键依赖关系的SQL

select
A.TABLE_NAME as OWNER,
B.TABLE_NAME as REFER
from
USER_CONSTRAINTS A,
USER_CONSTRAINTS B
where
A.OWNER='B00085_2' and
B.OWNER='B00085_2' and
A.CONSTRAINT_TYPE = 'R' and
A.R_CONSTRAINT_NAME = B.CONSTRAINT_NAME
order by
A.TABLE_NAME,
B.TABLE_NAME
;