randomizing names
Hi,
Why does the below BULK COLLECT / FORALL take so long? I'm no PL/SQL guru.
I know there is a data masking product. I've been working for a while trying to 'shuffle' names in tables. Here is my best idea so far, I quit waiting for execution completion after an hour or so. I've tried several things as you can see.
Objective: table mgl.dde_party has a column LAST_NAME_PERSON that I've like to 'shuffe / randomize' the name on.
I'm also open to any overall ideas as to how to 'randomize' names.
create table mgl.dde_party_ttt4 (rowid_v rowid, name varchar2(600));