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