Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: standard for storing SSNs?

Re: standard for storing SSNs?

From: Phillip Bump <pjbump_at_i1.net>
Date: 1997/10/05
Message-ID: <01bcd1cd$7ddf0540$cc30e6cf@default>#1/1

I concur with Greg's answer. You want to preserve all leading zeroes, and if you aren't going to be doing any arithmatic functions on the values in the column, make it CHAR or VARCHAR2.

-- 
Phillip Bump
pjbump_at_i1.net

Greg Kainz <gkainz_at_rmi.net> wrote in article <34353A86.2A9_at_rmi.net>...

> 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
> ------------------------------------------------------------
>
Received on Sun Oct 05 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US