OBJECT_OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the object that is redacted |
OBJECT_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the object that is redacted |
COLUMN_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the column that is redacted |
FUNCTION_TYPE |
VARCHAR2(27) |
|
Redaction function for this column |
FUNCTION_PARAMETERS |
VARCHAR2(1000) |
|
Redaction function_parameters for this column |
REGEXP_PATTERN |
VARCHAR2(512) |
|
Regular expression pattern to search for |
REGEXP_REPLACE_STRING |
VARCHAR2(4000) |
|
Replacement string (up to 4000 characters in length) with up to 500 back-references to subexpressions in the form \n, (where n is a number from 1 to 9) |
REGEXP_POSITION |
NUMBER |
|
Integer counting from 1, giving the position where the search should begin |
REGEXP_OCCURRENCE |
NUMBER |
|
Either 0 (to replace all occurrences of the match), or a positive integer n (to replace the nth occurrence of the match) |
REGEXP_MATCH_PARAMETER |
VARCHAR2(10) |
|
To change the default matching behavior, possible values are a combination of i, c, n, m, and x. See the documentation of the match_parameter in the REGEXP_REPLACE section of the Oracle Database SQL Language Reference. |
COLUMN_DESCRIPTION |
VARCHAR2(4000) |
|
User-provided description of the redaction function that is performed on the column. For example, for a Social Security Number column, the description might be: "redact SSN to XXX-XX-(last 4 digits)". |
