I have the following sample data and I just want to swap only the membereligids for the same fname,lname and dob
keeping the rest of the data as it is. The issue is there is unique constraint on the column Membereligids.
Please see the attached sample data
I am not sure how I can develop logic using CURSORS/FORALL. Can someone guide me ?
Eg: Fname - Amit
Lname - Kumar
has two records with the same DOB but with different membereligids. I want to swap only 40681910,40813962