# Setting the default displayed values for full redaction
<a name="Appendix.Oracle.CommonDBATasks.FullRedaction"></a>

To change the default displayed values for full redaction on your Amazon RDS Oracle instance, use the Amazon RDS procedure `rdsadmin.rdsadmin_util.dbms_redact_upd_full_rdct_val`. Note that you create a redaction policy with the `DBMS_REDACT` PL/SQL package, as explained in the Oracle Database documentation. The `dbms_redact_upd_full_rdct_val` procedure specifies the characters to display for different data types affected by an existing policy.

The `dbms_redact_upd_full_rdct_val` procedure has the following parameters.


****  

| Parameter name | Data type | Default | Required | Description | 
| --- | --- | --- | --- | --- | 
|  `p_number_val`  |  number  |  Null  |  No  |  Modifies the default value for columns of the `NUMBER` data type.  | 
|  `p_binfloat_val`  |  binary\$1float  |  Null  |  No  |  Modifies the default value for columns of the `BINARY_FLOAT` data type.  | 
|  `p_bindouble_val`  |  binary\$1double  |  Null  |  No  |  Modifies the default value for columns of the `BINARY_DOUBLE` data type.  | 
|  `p_char_val`  |  char  |  Null  |  No  |  Modifies the default value for columns of the `CHAR` data type.  | 
|  `p_varchar_val`  |   varchar2  |  Null  |  No  |  Modifies the default value for columns of the `VARCHAR2` data type.  | 
|  `p_nchar_val`  |  nchar  |  Null  |  No  |  Modifies the default value for columns of the `NCHAR` data type.  | 
|  `p_nvarchar_val`  |  nvarchar2  |  Null  |  No  |  Modifies the default value for columns of the `NVARCHAR2` data type.  | 
|  `p_date_val`  |  date  |  Null  |  No  |  Modifies the default value for columns of the `DATE` data type.  | 
|  `p_ts_val`  |  timestamp  |  Null  |  No  |  Modifies the default value for columns of the `TIMESTAMP` data type.  | 
|  `p_tswtz_val`  |  timestamp with time zone  |  Null  |  No  |  Modifies the default value for columns of the `TIMESTAMP WITH TIME ZONE` data type.  | 
|  `p_blob_val`  |  blob  |  Null  |  No  |  Modifies the default value for columns of the `BLOB` data type.  | 
|  `p_clob_val`  |  clob  |  Null  |  No  |  Modifies the default value for columns of the `CLOB` data type.  | 
|  `p_nclob_val`  |  nclob  |  Null  |  No  |  Modifies the default value for columns of the `NCLOB` data type.  | 

The following example changes the default redacted value to \$1 for the `CHAR` data type:

```
EXEC rdsadmin.rdsadmin_util.dbms_redact_upd_full_rdct_val(p_char_val => '*');
```

The following example changes the default redacted values for `NUMBER`, `DATE`, and `CHAR` data types:

```
BEGIN
rdsadmin.rdsadmin_util.dbms_redact_upd_full_rdct_val(
    p_number_val=>1,
    p_date_val=>to_date('1900-01-01','YYYY-MM-DD'),
    p_varchar_val=>'X');
END;
/
```

After you alter the default values for full redaction with the `dbms_redact_upd_full_rdct_val` procedure, reboot your DB instance for the change to take effect. For more information, see [Rebooting a DB instance](USER_RebootInstance.md).