データのマスキング

Oracleの場合

SQL> select * from employees where employee_id='100';

EMPLOYEE_ID FIRST_NAME		 LAST_NAME		   EMAIL		     PHONE_NUMBER	  HIRE_DAT JOB_ID	  SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
----------- -------------------- ------------------------- ------------------------- -------------------- -------- ---------- ---------- -------------- ---------- -------------
	100 Steven		 King			   SKING		     515.123.4567	  03-06-17 AD_PRES	   24000				      90

SQL> update employees
  2  set
  3  first_name=regexp_replace(first_name,'(.).','\1*'),
  4  last_name=regexp_replace(last_name,'(.).','\1*'),
  5  email=regexp_replace(email,'(.).','\1*'),
  6  phone_number=regexp_replace(phone_number,'(.).','\1*')
  7  where employee_id='100';

1行が更新されました。

SQL> select * from employees where employee_id='100';

EMPLOYEE_ID FIRST_NAME		 LAST_NAME		   EMAIL		     PHONE_NUMBER	  HIRE_DAT JOB_ID	  SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
----------- -------------------- ------------------------- ------------------------- -------------------- -------- ---------- ---------- -------------- ---------- -------------
	100 S*e*e*		 K*n*			   S*I*G		     5*5*1*3*4*6*	  03-06-17 AD_PRES	   24000				      90

参照したURL: http://systemengineer.hateblo.jp/entry/2013/01/17/125818

SQL Serverの場合

Sql Serverで取得項目をマスクする方法
https://qiita.com/kuro123/items/1bd4f923a255476f5567