Hi list,
Every night I update the development DB through a cron job, now I have the
requirement of change or scramble the names of our customers to protect and privacy
of information. I have been thinking of adding a procedure to the script that
update all the names using a REPLACE
Ramon,
Take a look at the DBMS_RANDOM package. You can replace the name with a
random number. That ought to do the trick.
Good Luck
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, January 16, 2004 7:49 AM
To: Multiple recipients of list ORACLE-L
Hi