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: Richard <qaz1521_at_hotmail.com>
Date: Wed, 26 Nov 2003 02:37:55 -0000
Message-ID: <bq13m3$fk0$1$8302bc10@news.demon.co.uk>


Do you need to search on the whole phone number, e.g. to identify an individual subscriber or do you just need to identify the 'location' of the phone number, e.g. to identify which exchange or charge group it is associated with?

Regards,

Richard

"v5034" <v5034_at_vm.vm.co> wrote in message 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?
>
> Thanks
>
Received on Tue Nov 25 2003 - 20:37:55 CST

Original text of this message

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