Dear Tom,

We have a requirement to mask (data should not be readable) certain columns of a row, based on certain conditions.
For example, in a development environment, for data protection purposes, the information of the table customer needs to be masked based on certain condition.

CREATE TABLE customer (
    last_name    VARCHAR2(25),
    first_name   VARCHAR2(25),
    address      VARCHAR2(25),
    sensitive_Data char
);

insert into customer values('A', 'A', '10','N'); 
insert into customer values('B', 'B', '11','N'); 
insert into customer values('C', 'C', '12','Y'); 

In the production environment, if we do a select on customer, the result will be as follows:

select *
from customer;

LAST_NAME  FIRST_NAME  ADDRESS SENSITIVE_DATA 
-------- ---------- ------- -------------
A   A 10    N 
B    B  11   N 
C    C  12   Y 

In the development environment, the same information needs to be masked as below:

LAST_NAME  FIRST_NAME  ADDRESS SENSITIVE_DATA 
-------- ---------- ------- -------------
A   A 10    N 
B    B  11   N 
XX    XX  12   Y 

We tried to use DBMS_REDACT feature, this is masking the whole column instead of specific row, we would like to understand if ever there is any utility/package shared by oracle to meet this requirement

Thanks & Regards,
Devalam Suchindra

create view SENSITIVE as select * from CUSTOMER where SENSITIVE_DATA = 'Y';

create view V_CUSTOMER as
select * from SENSITIVE
union all
select * from CUSTOMER where SENSITIVE_DATA = 'N'