Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: cross reference index
In article <909d0o$s91_at_dispatch.concentric.net>,
"Jim Poe" <jpoe_at_fulcrumit.com> wrote:
>
>
> --
> Jim Poe ( jpoe_at_fulcrumit.com )
>
> > One could automate this for the user -- parsing out spaces and
> > converting then into '%'. Not hard programming.
> >
> > I have written code that did lookup based on the initial letters -->
> > looking for 'ACME' as company_name like 'A%C%M%E%'. Again for small
> > tables (~10,000 rows) the database was more than fast enough
especially
> > if the company_name was part of an index. Again not hard
programming in
> > forms.
>
> Hmm, maybe I am not being creative enough with the 'like' syntax.
What is
> 'A%C%M%E%' saying?
Is is trying to match anything with A followed by zero of more letters than 'C' followed by zero or more letters ...
It is useful to match kind-a-sorta spelling of words
eg mcdonald would find 'mac donald', 'mc donald', 'mcdonalds'
Oracle is of course case sensitive and would not find 'McDonald'
Good news is that indexes can have functions like upper() to convert all data to upper for searching.
>
> >
> > Approach two is to generate the company word index table/index. You
can
> > create the rows by doing the parsing and inserting the data into the
> > table. You might want to develop triggers -- to add/update/delete
rows
> > in the index table when you add/update/delete company rows. Not hard
> > programming -- but a little bit of work.
>
> I thought about this, and I think it may be the closest match to the
cross
> reference index.
>
> >
> > By the way what database has this cross referencing built-in?
> > --
>
> It is called Advanced Revelation, a Pick derivative.
>
> Thanks
>
>
-- Michael Krolewski Rosetta Inpharmatics mkrolewski_at_rosetta.org Ususual disclaimers Sent via Deja.com http://www.deja.com/ Before you buy.Received on Fri Dec 01 2000 - 18:32:58 CST