Re: standard for storing SSNs?

From: Michael Serbanescu <mserban_at_postoffice.worldnet.att.net>
Date: 1997/10/03
Message-ID: <3435C883.5DD5@postoffice.worldnet.att.net>#1/1

To "mask" the SSN, try this:

SELECT DECODE(ssn,'999-99-999',ssn,'999-99-999') FROM <table_name>;

Hope this helps.

Michael Serbanescu

---

Beth Powers wrote:
>
> yes, i'm new at this oracle stuff.
>
> given that, is there a "standard" for storing social security numbers?
> also, in other DBMS packages i've used, there were ways to "mask" the data
> so that it displayed 999-99-9999. is there a way to do that in oracle?
>
> thanks in advance.
>
> Gentle breezes,
> ----------------------------------
> Beth Powers
> bpowers_at_fiore-ind.com
> Fiore Industries, Inc.
Received on Fri Oct 03 1997 - 00:00:00 CDT