Mask an entire data type with a matching mask in any SELECT query.

Syntax

/*+  MASK_FULL(column [, length]) */

Arguments

  • column - name of table column.
  • length - length of mask.

Results

Data Type Mask Example value Mask value
String XXXX DaffyDuck XXXXXXXXXX
Numeric, Binary 0 12345 00000
Date and timestamp 01-01-1980 23-11-2019 01-01-1980
Not specified Best guess    
Boolean False    
Col3 binary Not Null 0    
Col4 bolean not null =>    
Col xml not null => {}    

Examples

SELECT MASK_FULL(id), * FROM widgetcorp.sales.accounts.customers;

| RESULTS | id | name | surname | email |
|---|---|---|---|---|
| 00000 | 39772 | eddie | gaff | egaff@lapd2019.gov |
| 00000 | 23381 | dave | holden | holden.d@turtle.com |
| 00000 | 26354 | rick | deckard | rick@unicorn.co |

MASK_FULL(name), * FROM widgetcorp.sales.accounts.customers;

| RESULTS | id | name | surname | email |
|---|---|---|---|---|
| XXXXX | 39772 | eddie | gaff | egaff@lapd2019.gov |
| XXXX | 23381 | dave | holden | holden.d@turtle.com |
| XXXX | 26354 | rick | deckard | rick@unicorn.co |