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

Home -> Community -> Usenet -> c.d.o.server -> Re: Phone Numbers

Re: Phone Numbers

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Wed, 26 Nov 2003 17:35:14 +0100
Message-ID: <bq2ko4$40g$1@news.fujitsu-siemens.com>

"v5034" <v5034_at_vm.vm.co> schrieb im Newsbeitrag news:vs80klekuf1pb3_at_news.supernews.com...
> What is the best way to store, index and search N. American phone
> numbers for maximum search efficiency? Should they be broken up and
> stored as area code columns and number columns? How should they be
> indexed? I have a standard Oracle database - not EE.
> How should they be searched for efficiency?
Do you want to search independently for area codes? Does the number you want to check contain no area code? If both questions can be answered "yes", why bother with a split?

Lots of Greetings!
Volker Received on Wed Nov 26 2003 - 10:35:14 CST

Original text of this message

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