User Guide

9.9
- 9.9.4
- 9.9.3
- 9.9.2
- 9.9.1
- 9.8.4
- 9.8.3
- 9.8.2
- 9.8.1
- 9.8.0

Back Next

Scrambling Functions

A scrambling function is a masking technique that rearranges values in the requested data. Scrambling functions use Oracle database syntax and are created by using the security rule Mask action.

The following table describes examples of scrambling functions.

Scrambling Function	Description
translate(reverse(\(col)), '1234567890', '97865301')	Scrambles the locations of the digits.
max(\(col)) over(order by empno rows between 1 and preceding and 1 following)	Provides list scrambling. The Rule Engine replaces the name with the letter value of the preceding and subsequent records.
nvl( lead(ename) over (order by ename), first_value(ename) over ( order by ename)	Offsets the address by a single row. If the value is null, the Rule Engine assigns the first_value of ename found in the emp table after sorting by ename .

Rename Saved Search

Table of Contents

User Guide

User Guide

Scrambling Functions

Scrambling Functions