Skip to Main Content
Forums

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!

format mask ssn using oracle

Kevin_KFeb 5 2008 — edited Feb 5 2008
Is there any way to put a format mask using SQL to hide SSN number after the data is retrieved from select:

example:

ssn formatted ssn
772-88-8888 xxx-xx-xxxx

Thank You
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 4 2008
Added on Feb 5 2008
3 comments
1,252 views