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!

Masking Card number

imation3mAug 1 2016 — edited Aug 1 2016

I have to update card number column in a table with masked card number.

Number of records in this table are more than 500,000.

Existing card no: 4673620100000119

Masked card no: 467362******0119

what will be the fasted to achieve this update, though regexp or substr?

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 29 2016

Added on Aug 1 2016

#oracle

9 comments

3,188 views