There is a need of masking data which is to basically mask customer related sensitive data across multiple columns in a table.
So, I started looking into DBMS_CRYPTO , DBMS_REDACT & Transparent Data Encryption(TDE) column level encryption concepts of Oracle and been analyzing to find out the suitable approach with least prerequisites and minimal performance impact.
Also, pls confirm if columns with masked data can be used in joins.
Thank u.