Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to mask and unmask a creditcard number in oracle

970843Feb 5 2013 — edited Feb 6 2013

Hi,

Is there a way to mask a creditcard number from

"1234-5678-4321-8765" to "XXXX-XXXX-XXXX-XXXX" and unmask it back to readable format

using regular expressions in oracle?

Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 6 2013

Added on Feb 5 2013

#11g, #9i, #database, #dba, #oracle, #sql

18 comments

10,690 views