推荐订阅源

查询表中指定库名，表约束名的上下表依赖关系

SELECT 
    a.table_name AS 子表名,
    a.column_name AS 子表关联字段,
    c.table_name AS 父表名,
    c.column_name AS 父表关联字段
FROM all_cons_columns a
JOIN all_constraints b ON a.owner = b.owner AND a.constraint_name = b.constraint_name
JOIN all_cons_columns c ON b.r_owner = c.owner AND b.r_constraint_name = c.constraint_name
WHERE a.owner = 'NJ_GROUP_USER' 
  AND b.constraint_name = 'SYS_C0026024'
;