资讯详情

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

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'
;