Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

"shuffle" the data in a table..

phani marellaMar 10 2010 — edited Mar 12 2010
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
This post has been answered by Frank Kulash on Mar 10 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 9 2010
Added on Mar 10 2010
10 comments
2,961 views