数据脱敏

update qc_rd_index s set CHECK_USERS=(select (select wm_concat(to_char(replace(REGEXP_SUBSTR(CHECK_USERS,
'[^,]+',
1,
rownum),
substr(REGEXP_SUBSTR(CHECK_USERS,
'[^,]+',
1,
rownum),
2,
1),
'*')))
from dual
connect by rownum <=
LENGTH(CHECK_USERS) - LENGTH(regexp_replace(CHECK_USERS, ',', '')) + 1) as users
from qc_rd_index a where CHECK_USERS is not null and s.id=a.id) where CHECK_USERS is not null

posted on   小小小传说  阅读(7)  评论(0编辑  收藏  举报

努力加载评论中...

导航

点击右上角即可分享
微信分享提示