Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: CONTEXT Options
You can try searching using a "like" command even though there will be some degradation in the performance.
Select <long field> from <table name>
where <long filed> like '%456%'
//dinesh
Ed Jennings wrote in message <3506077F.5868_at_mindspring.com>...
>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 Wed Mar 11 1998 - 00:00:00 CST