Hi everyone...
Pleade help me to solve this issue.
Is it possible to shuffle the data in a table?
Let say if i have a table with following data..
PERSON_ID PERSON_LAST_NAME PERSON_FIRST_NAME DOB
1 Test1 Test1 01/01/1970
2 Test2 Test2 01/01/1971
3 Test3 Test3 01/01/1972
4 Test4 Test4 01/01/1973
5 Test5 Test5 01/01/1974
I am trying to shuffle the above data so that no person will have their
"real last,first and dob match".
I need the output like this or in any combinations so that no one can
identify a person actual "last name,first name and dob"
PERSON_ID PERSON_LAST_NAME PERSON_FIRST_NAME DOB
1 Test1 Test2 01/01/1974
2 Test2 Test4 01/01/1975
3 Test3 Test5 01/01/1971
4 Test4 Test3 01/01/1972
5 Test5 Test1 01/01/1973
please help me to solve this issue. Thanks in advance