dbms_redact

Adding a redaction policy

begin
  dbms_redact.add_policy(
    object_schema    => 'hr',
    object_name      => 'the_table',
    column_name      => 'sensitive_column',
    policy_name      => 'hide_data',
    function_type    =>  dbms_redact.full,
    expression       => '1=1'
  );
end;
/

See also