The email address is fully masked with the exception of the first and last character.

Syntax

/*+  MASK_EMAIL1(column) */

Arguments

  • column - name of table column.

Examples

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

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