Use a hashing function to change the column value. If no type specified, MASK_HASH uses SHA-256.

Syntax

/*+  MASK_HASH(column [, type]) */

Arguments

  • column - name of table column.
  • type - MD5, SHA‌-1, SHA‌-256.

Examples

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

| RESULTS | id | name | surname | email |
|---|---|---|---|---|
| 7112C@2E43DA9B.7C3	 | 39772 | eddie | gaff | egaff@lapd2019.gov |
| 044057.1@65DD7E.D5A	 | 23381 | dave | holden | holden.d@turtle.com |
| 4CF3@DC22E5C.27	 | 26354 | rick | deckard | rick@unicorn.co |