Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> CONTEXT Options

CONTEXT Options

From: Ed Jennings <jenningse_at_mindspring.com>
Date: 1998/03/10
Message-ID: <3506077F.5868@mindspring.com>#1/1

I'm running Oracle 7.3.3 with the context option. I have a LONG column that contains ascii text. Within the data is embedded phone numbers with and without embedded formatting (i.e. "123-456-7890" and/or "1234567890").

Searches with CONTAINS '456' would locate the first form only.
Searches with CONTAINS '1234567890' would locate the second form only.
Searches with CONTAINS '123-456-7890' would not locate any rows.

I'm using all default values when I set up my POLICY. Are there any options that I can use to cause searches to be a little more flexible? In the example above, I'd like a search on '456' to return both of those rows as hits.

TIA
Ed Jennings

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~
jenningse_at_mindspring.com

"The opinions expressed here are my own, not those of DOMAIN
technologies"
Received on Tue Mar 10 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US