Select
a.Owner,
c.Column_Name,
a.Table_Name,
c.Constraint_Name || ‘;’
From User_Constraints a, user_Cons_Columns c
Where a.Constraint_Type = ‘R’ And a.Constraint_Name = c.Constraint_Name And a.Owner = c.Owner And a.Table_Name = c.Table_Name;