===== Data Redaction =====
Uses the DBMS_REDACT package.\\
The following procedures can be used ...
  * ADD_POLICY
  * ALTER_POLICY
  * DISABLE_POLICY
  * DROP_POLICY
  * ENABLE_POLICY

The following Function Types are available ...
  * DBMS_REDACT.NONE
  * DBMS_REDACT.FULL
  * DBMS_REDACT.PARTIAL (Number, Character, Date)
  * DBMS_REDACT.RANDOM

The below examples fully redacts all details in the card_no column.
<code>BEGIN
  DBMS_REDACT.add_policy(
    object_schema => 'c##ian',
    object_name   => 'payment_details',
    column_name   => 'card_no',
    policy_name   => 'redact_card_info',
    function_type => DBMS_REDACT.full,
    expression    => '1=1'
  );
END;</code>
There is a EXEMPT REDACTION POLICY privilege.\\
CTAS commands against a redacted table will fail.\\
Redaction does not apply to the WHERE clause.\\

[[https://oracle-base.com/articles/12c/data-redaction-12cr1|Oracle Base Article]]