Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Phone Numbers
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