MASK_EMAIL3 masks the entire email except the domain and suffix.

Syntax

/*+  MASK_EMAIL3(column) */

Arguments

  • column - name of table column.

Examples

SELECT MASK_EMAIL3(email), * FROM widgetcorp.sales.accounts.customers

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