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
