Dynamic Data Masking
- Dynamic Data Masking 9.9.3
- All Products
emp_id IN NUMBER, job_id IN NUMBER, salary_rec OUT SYS_REFCURSOR
Column
| Masking Function
|
---|---|
.*SALARY
| 999
|
.*COMM
| \(col)-FLOOR(\(col) / 7)*7
|
.*Last_Name
| substr(\(col),1,2)
|
The ? is a placeholder for the REF_CURSOR as OUT parameter.CALL Proc_Dept_Emp(25,10, ?)
CALL TEMPDB.P1436942931536_2 (25,10,? )
SELECT EMPLOYEE_ID , substr(LAST_NAME ,1,2) LAST_NAME , FIRST_NAME , MIDDLE_NAME , JOB_ID , MANAGER_ID , HIREDATE , 999 SALARY , COMM -FLOOR(COMM / 7)*7 COMM , DEPARTMENT_ID , EMAIL FROM TEMPDB . T_1436942931536 ;