脱敏操作：包括身份证、银行卡、详细地址（oracle数据库中）

create tabletm_app_main_bak as select * from tm_app_main;
update tm_app_main set ID_NO =  '110000'||substr(id_no,7) , unique_id = 'I'||'110000'||substr(unique_id,8),cellphone = '12345678901';
select p.abode_detail from tm_app_prim_applicant_info p ;
update tm_app_prim_applicant_info set abode_detail = '*************************' , bank_card_no = substr(bank_card_no,0,14)||'*****'
,bank_card_nbr = substr(bank_card_nbr,0,14)||'*****';

转载于:https://www.cnblogs.com/zgxz/p/8046048.html