select uc.table_name, uc.r_constraint_name, ucc.table_name,
listagg(ucc.column_name, ',') within group (order by ucc.column_name)
over (partition by uc.table_name, uc.r_constraint_name)
from user_constraints uc, user_cons_columns ucc
where uc.r_constraint_name = ucc.constraint_name and uc.constraint_type = 'R'
order by uc.table_name, uc.r_constraint_name, ucc.table_name, ucc.column_name;