脱敏操作:包括身份证、银行卡、详细地址(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