sql - String masking with Regex at Oracle

Question

I want to mask name and surname in Oracle. For example; John Smith => Jo** Sm**

I can write a PL/SQL function. But i want to do this with regex. I can't write the right template. Is regex the right solution? Is there anyone who can help?

标签： sqlregexoracle

Answer 1

如果你想用正则表达式来做，你可以使用以下内容：

REGEXP_REPLACE('John Smith', '(\w{2})\w+', '\1**')