Dynamic Data Masking Default Masking Functionality

Back Next

General Use Case #2: SQL statement with explicit column list (that does not contain the WHERE, GROUP BY, HAVING, or ORDER BY clauses)

Use case #2 provides an example of a SQL statement that does not contain the WHERE, GROUP BY, HAVING, or ORDER BY clauses. In this scenario, the Original Number of Rows check box is not relevant.

Example statement:

select FIRST_NAME,LAST_NAME||'.' from EMPLOYEES

The following table describes the example masking scenarios:

Keep Original Number of Rows	Old Masking Statement Modification	New Masking Statement Modification	Masking Action Functionality
N or Y	select substr("FIRST_NAME",1,2) "FIRST_NAME" ,substr("LAST_NAME",1,2)\|\|'zzzz' \|\| '.' from EMPLOYEES	select substr(FIRST_NAME,1,2) FIRST_NAME ,substr(LAST_NAME ,1,2)\|\|'zzzz'\|\| '.' C_X0 from EMPLOYEES	Old masking functionality: Col List – Y New masking functionality: Col List – Y If a candidate column is a part of an expression and does not have a column alias, the new masking algorithm adds a column alias to the candidate column. This is done to hide the masking function if applied.

Rename Saved Search

Table of Contents

Dynamic Data Masking Default Masking Functionality

Dynamic Data Masking Default Masking Functionality

General Use Case #2: SQL statement with explicit column list (that does not contain the WHERE, GROUP BY, HAVING, or ORDER BY clauses)

General Use Case #2: SQL statement with explicit column list (that does not contain the WHERE, GROUP BY, HAVING, or ORDER BY clauses)