Pattern matching in Oracle.
From: Roland Dunn <roland_dunn_at_hotmail.com>
Date: Thu, 24 Aug 2000 11:24:53 GMT
Message-ID: <9C7p5.180$NR3.17252_at_news1.cableinet.net>
Date: Thu, 24 Aug 2000 11:24:53 GMT
Message-ID: <9C7p5.180$NR3.17252_at_news1.cableinet.net>
[Quoted] Wonder if anyone can help.
[Quoted] I have a data set where potentially one record could have upto 100 numerical
[Quoted] fields, each numercial field being a floating point number between say 0 and
5.
[Quoted] 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
[Quoted] 2.99 +/- 0.02, field 56 has a value of 1.34 +/- 0.04. This query may include
[Quoted] 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 - 13:24:53 CEST