MASK_RANDOM returns a random value from that has the same length as the original value.

Syntax

/*+  MASK_RANDOM(column) */

Arguments

  • column - name of table column.

Examples

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

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