Re: Pattern matching in Oracle.

Jeff,

Thanks for replying. There would be 100 columns.

Knowing this if you think the context cartridge is really what I should look at, do you know where I can find out more information? I've just done a quick search on the Oracle site and not anything that helpful. You wouldn't by any chance have a URL handy .....

Roland.

> Are the fields all stuffed into one column, or are there 100 columns,
> only some of which are usually filled or what?
>
> The context cartridge is pretty powerful.
>
> Jeff Kish
> On Thu, 24 Aug 2000 11:24:53 GMT, "Roland Dunn"
> <roland_dunn_at_hotmail.com> wrote:
>
> >Wonder if anyone can help.
> >
> >I have a data set where potentially one record could have upto 100
 numerical
> >fields, each numercial field being a floating point number between say 0
 and
> >5.
> >I would like to run a query whereby I say something like: find me the
> >records where field 20 has a value of 3.5 +/- 0.05, field 80 has a value
 of
> >2.99 +/- 0.02, field 56 has a value of 1.34 +/- 0.04. This query may
 include
> >all fields.
> >
> >Can this approximate searching or pattern matching be done somehow in
> >Oracle?
> >Is there a plugin or a cartridge that could enable such functionality?
> >
> >Hope someone can help.
> >Thanks, Roland.
> >
> >
> >
>
>
>
Received on Thu Aug 24 2000 - 14:28:47 CEST