Oracle 视图 REDACTION_EXPRESSIONS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图REDACTION_EXPRESSIONS用于定义数据保护表达式（Data Protection Expressions – DPE）。数据保护表达式是一种用于保护敏感数据的表达式，当某列所存储的数据符合保护表达式定义的要求时，该行将被删除或替换其中符合要求的列中的数据。
使用REDACTION_EXPRESSIONS可以从Oracle表中查询敏感数据，当需要更新或删除敏感数据时，还可以通过REDACTION_EXPRESSIONS提供的精准的查询来查找这些数据，然后再将其进行处理。
REDACTION_EXPRESSIONS也可以用于根据不同的用户操作来动态更改数据保护表达式的定义，从而更准确的保护数据安全。
官方英文解释
REDACTION_EXPRESSIONS shows all the Data Redaction named Policy Expressions in the database.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Customer-specified name of the named Policy Expression |
|
|
|
|
The SQL expression defined for this Data Redaction named Policy Expression |
|
|
|
|
Owner of the table or view which this named Policy Expression is associated with |
|
|
|
|
Name of the table or view which this named Policy Expression is associated with |
|
|
|
|
Name of the column which this named Policy Expression is associated with |
|
|
|
|
Description of this named Policy Expression |
