Re: Need data masking function ideas...
- From: Michael Moore <michaeljmoore@xxxxxxxxx>
- To: robertgfreeman@xxxxxxxxx
- Date: Fri, 6 May 2011 12:30:07 -0700
NM, you said you wanted the length to remain the same. On Fri, May 6, 2011 at 12:29 PM, Michael Moore <michaeljmoore@xxxxxxxxx>wrote: > could you use ORA_HASH? > > > On Fri, May 6, 2011 at 11:45 AM, Robert Freeman > <robertgfreeman@xxxxxxxxx>wrote: > >> Ok.... So I'm doing some data masking. The problem is that I have many >> many tables that have related columns with no FK's... I'm going to use the >> data masking pack to do the masking, but it does not offer the complete >> functionality I need since the FK's are not in place. So I need a function >> to call from the job to do most of the actual masking. >> >> I want to make sure that when I mask a given column that the following is >> true: >> >> 1. The data length remains the same. >> 2. That the mask value for a given value remains the same. >> >> For example, if on table A I have a column called test_col with rows with >> values 1,2,3 and these mask to 3,1,6 , values 32,555,6433 will mask to >> something like 22, 345 and 5500... >> >> that on table B the same result will occur. >> >> Now I know I can come up with a deterministic masking function/strategy to >> do this, but I'm wondering if anyone else has any ideas. >> >> Thanks in advance... >> >> Robert G. Freeman >> Master Principal Consultant, Oracle Corporation, Oracle ACE >> Author of various books on RMAN, New Features and this shorter signature >> line. >> Blog: http://robertgfreeman.blogspot.com >> >> Note: THIS EMAIL IS NOT AN OFFICIAL ORACLE SUPPORT COMMUNICATION. It is >> just the opinion of one Oracle employee. I can be wrong, have been wrong in >> the past and will be wrong in the future. If your problem is a critical >> production problem, you should always contact Oracle support for assistance. >> Statements in this email in no way represent Oracle Corporation or any >> subsidiaries and reflect only the opinion of the author of this email. >> >> >> ------------------------------ >> *From:* Lei Zeng <lzeng@xxxxxxxxxxxxx> >> *To:* "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx> >> *Sent:* Thu, May 5, 2011 9:33:23 PM >> *Subject:* how to find the name for SQL_OPCODE >> >> Hi, list: >> >> >> >> I am on 10g, not 11g. How to find out the complete list of names for >> SQL_OPCODE? I want to do something like >> >> >> >> decode(OPCODE >> >> 0,'BACKGROUND', >> >> 1,'Create Table', >> >> 2,'INSERT', ….) >> >> >> >> Thanks, >> >> Lei >> >> >> > >