2020年11月2日11:33:24-数据库表敏感字段值脱敏处理

最新推荐文章于 2024-10-11 02:58:18 发布

宏伟中国

最新推荐文章于 2024-10-11 02:58:18 发布

阅读量340

点赞数

本文链接：https://blog.csdn.net/qq_21764833/article/details/109445698

版权

UPDATE A01 SET A0101=SUBSTR(A0101,1,1)||'一二' WHERE SUBSTR(A00,1,1)='1';
UPDATE A01 SET A0101=SUBSTR(A0101,1,1)||'三一' WHERE SUBSTR(A00,1,1)='2';
UPDATE A01 SET A0101=SUBSTR(A0101,1,1)||'二三' WHERE SUBSTR(A00,1,1)='3';
UPDATE A01 SET A0101=SUBSTR(A0101,1,1)||'四五' WHERE SUBSTR(A00,1,1)='4';
UPDATE A01 SET A0101=SUBSTR(A0101,1,1)||'三七' WHERE SUBSTR(A00,1,1)='5';
UPDATE A01 SET A0101=SUBSTR(A0101,1,1)||'一五' WHERE SUBSTR(A00,1,1)='6';
UPDATE A01 SET A0101=SUBSTR(A0101,1,1)||'五三' WHERE SUBSTR(A00,1,1)='7';
UPDATE A01 SET A0101=SUBSTR(A0101,1,1)||'七九' WHERE SUBSTR(A00,1,1)='8';
UPDATE A01 SET A0101=SUBSTR(A0101,1,1)||'八九' WHERE SUBSTR(A00,1,1)='9';
UPDATE A01 SET A0101=SUBSTR(A0101,1,1)||'六七' WHERE UPPER(SUBSTR(A00,1,1))='A';
UPDATE A01 SET A0101=SUBSTR(A0101,1,1)||'八六' WHERE UPPER(SUBSTR(A00,1,1))='B';
UPDATE A01 SET A0101=SUBSTR(A0101,1,1)||'八七' WHERE UPPER(SUBSTR(A00,1,1))='C';
UPDATE A01 SET A0101=SUBSTR(A0101,1,1)||'三五' WHERE UPPER(SUBSTR(A00,1,1))='D';
UPDATE A01 SET A0101=SUBSTR(A0101,1,1)||'六七' WHERE UPPER(SUBSTR(A00,1,1))='E';
UPDATE A01 SET A0101=SUBSTR(A0101,1,1)||'零零' WHERE UPPER(SUBSTR(A00,1,1))='F';
SELECT * FROM A01;