Oracle Data Redaction provides a variety of ways to redact different types of data.

• Getting Started with Oracle Data Redaction
  You can create and enable Oracle Data Redaction policies by using the DBMS_REDACT package. You define redaction policies by specifying the schema, object, and column.
• Full Data Redaction to Redact All Data
  Full data redaction redacts the entire contents of a specified column of a table or view.
• Partial Data Redaction to Redact Portions of Data
  In partial data redaction, you redact portions of the displayed output.
• Regular Expressions to Redact Patterns of Data
  Regular expressions redact specific data within a column data value, based on a pattern search. You can use regular expressions to redact a column of strings of different lengths.
• Random Data Redaction to Generate Random Values
  In random data redaction, the entire value is redacted by replacing it with a random value.
• Redaction Using Null Values
  You can create an Oracle Data Redaction policy that redacts column data by showing only null values in the query result.
• No Redaction for Testing Purposes
  You can create a Data Redaction policy that does not perform redaction. This enables you to include redaction policies in your applications during testing, and then apply those polices to your data as you move the application to production.
• Comparison of Full, Partial, Regexp, Random, and Nullify Redaction Based on Data Types
  The full, partial, regular expression, random, and nullify data redaction styles affect the Oracle built-in, ANSI, user-defined, and Oracle supplied types in different ways.
• Central Management of Data Redaction Named Policy Expressions
  You can create named policy expressions that can be used in the columns of multiple tables and views.