DBMS_REDACT does not work on 19c
Here is a testing case that works on 11g but not 19c.
drop table dbadmin.creditcard;
create table dbadmin.creditcard (cust_id number(4) primary key, card_no varchar2(19), gate_name varchar2(20), expiry_date DATE, PIN number(4));
insert into dbadmin.creditcard values(1000,'1234-1234-1234-1234','VISA POWER','01-JAN-2022',5555);
insert into dbadmin.creditcard values(1001,'2323-2323-2323-2323','VISA POWER','01-MAR-2028',6666);
insert into dbadmin.creditcard values(1002,'4321-4321-4321-4321','RUPAY GATE','09-JAN-2026',9999);
insert into dbadmin.creditcard values(1003,'6789-6789-6789-6789','VISA POWER','31-DEC-2022',8888);
insert into dbadmin.creditcard values(1004,'1234-5678-1234-5678','RUPAY GATE','31-DEC-2024',7777);