MASK_SSN masks the last 4 characters of the social security number value, and does not accept any other parameter.

Syntax

/*+  MASK_SSN(column) */

Arguments

  • column - name of table column.

Examples

SELECT MASK_SSN(ssn), * FROM widgetcorp.sales.accounts.customers;

| RESULTS | id | name | surname | email | phone | ssn |
|---|---|---|---|---|---|---|
| XXX-XX-8437 | 39772 | eddie | gaff | egaff@lapd2019.gov | 202-555-0157 | 434-01-8437 |
| XXX-XX-5252 | 23381 | dave | holden | holden.d@turtle.com | 202-555-0161 | 518-22-5252 |
| XXX-XX-2949 | 26354 | rick | deckard | rick@unicorn.co | 202-555-0139 | 413-39-2949 |