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?

Answer 1

If you want todo it with regexp you can use the following:

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