Desensitization operation: Includes ID card, bank card, detailed address (in Oracle database)

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) | | ' ‘;

Desensitization operation: Includes ID card, bank card, detailed address (in Oracle database)