Hi Team,
I have a production database table emp. Now I want to mask empno column.
Example:
Acual Data in the EMP table:
-----------------------------------
EMPNO: 0000123456789
I want like a "000XXXX789"
Please suggest.
Actully, I have one query, But i am not understand that query.
update EMP set EMPNO=substr(EMPNO,1,5) || regrep_replace(substr(EMPNO,6,5),'[0-9]',9)
||substr(EMPNO,11,5) || regrep_replace(substr(EMPNO,16,5),'[0-9]','9') || substr(EMPNO,21,5);
Note: dataabse Version is 11g.
Thanks,
Raman....