RE: Opinion on Changing Names

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
> restevez_at_blh.com.do
> 809-535-8994
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mercadante, Thomas F
  INET: thomas.mercadante_at_labor.state.ny.us

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: ListGuru_at_fatcity.com (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).