Re: Need data masking function ideas...

On Fri, May 6, 2011 at 11:45 AM, Robert Freeman <robertgfreeman_at_yahoo.com>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_at_yahoo-inc.com>
> *To:* "oracle-l_at_freelists.org" <oracle-l_at_freelists.org>
> *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
>
>
>

--
http://www.freelists.org/webpage/oracle-l