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 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 clause and change some letters. > > Is there any way or a better one to accomplish that ? > > Scenario 8.1.7.4 from HP-UX (Prod) to RH AS 1.2 8.1.7.4 (lab). > > TIA > > Ramon E. Estevez > [EMAIL PROTECTED] > 809-535-8994 > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
