select
c.table_name,
c.constraint_name,
c.constraint_type,
c.status,
c.r_owner,
c.r_constraint_name,
(select rc.table_name from all_constraints rc where rc.owner = c.r_owner and rc.constraint_name = c.r_constraint_name) as r_table_name,
c.delete_rule,
(
select listagg(column_name || ':' || position,',') within group (order by "position")
from all_cons_columns col
where col.owner =:1 and col.table_name = :2 and col.constraint_n