Re: Storing phone info...

• Suzy Vordos <lvordos_at_qwest.com>

>
>
> Curious how people are storing phone info in their database, eg.,
> separate columns for country code, city code, area code, etc. Any
> references about this would be appreciated!

Useful for fast scans by a/c or prefix. Depends on the use. Indexes on these are usually a waste (not specific enough) but for a count(*) by a/c it beats having to substr the entire thing.

--
Steven Lembark                               2930 W. Palmer
Workhorse Computing                       Chicago, IL 60647
                                            +1 800 762 1582
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steven Lembark
  INET: lembark_at_wrkhors.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).