Opinion on Changing Names

2004-01-16 Thread Ramón Estevez
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

RE: Opinion on Changing Names

2004-01-16 Thread Mercadante, Thomas F
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