PL/SQL (MOSC)

MOSC Banner

randomizing names

edited Oct 25, 2016 5:00AM in PL/SQL (MOSC) 2 commentsAnswered

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));

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center