Re: standard for storing SSNs?

If you're using Oracle Forms (or other front end development tool) then store them as char(9) and mask or format the number in the tool, otherwise make them char(11) and store the dashes...

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.
 

               DataWeb Consulting Services, Inc.
              "Web-enabling your databases today"
voice:(303)517-3863                       FAX:(303)422-5107
                       gkainz_at_rmi.net
------------------------------------------------------------