create table tom_redact_test (
id        number,
ssn       varchar2(10),
nr1       number,
nr2       number,
constraint trt_pk primary key (id))

insert into tom_redact_test (id, ssn, nr1, nr2) values (1, '1234567890', 10, 10)

insert into tom_redact_test (id, ssn, nr1, nr2) values (2, '9876543210', 20, 20)

insert into tom_redact_test (id, ssn, nr1, nr2) values (3, '0567891234', 30, 30)

insert into tom_redact_test (id, ssn, nr1, nr2) values (4, '7481592630', 40, 40)

insert into tom_redact_test (id, ssn, nr1, nr2) values (5, '9510623847', 50, 50)

commit

begin
  dbms_redact.add_policy(object_schema => user,
                         object_name => 'TOM_REDACT_TEST', column_name => 'SSN', 
                         policy_name => 'tom redact test ssn',
                         function_type => dbms_redact.partial, 
                         function_parameters => 'vvvvvvvvvv,vvvvvvvvvv,*,1,4', 
                         expression => '1=1');
end;

select * from tom_redact_test

create or replace view tom_redact_view_ok as
select id, ssn, nr1, nr2 from tom_redact_test

create or replace view tom_redact_view_28094 as
select id, ssn, nr1, nr2, 
       nr1 + nr2 my_sum
  from tom_redact_test

select * from tom_redact_view_ok

select * from tom_redact_view_28094

select id, ssn, nr1, nr2 from tom_redact_view_28094

exec dbms_redact.drop_policy(object_schema => user, object_name => 'TOM_REDACT_TEST', policy_name => 'tom redact test ssn')

drop view tom_redact_view_28094

drop view tom_redact_view_ok

drop table tom_redact_test purge