Re: standard for storing SSNs?

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.

select to_char(ssn,'999-99-9999') from yourtable;

-- 
Sheilah Scheurich
DBA

My opinions are my own and not that of my 
employer.

To respond via email, remove underscores.