I need to ask a question of someone who understands Oracle Text
indexes. So if you know Oracle Text, please read on.
I was told that if I had a query such as the following:
SELECT falls_name
FROM waterfalls
WHERE INSTR(UPPER(falls_directions),
'MACKINAC BRIDGE') <> 0;
where falls_directions is a CLOB, that I can define a case-insensitive
index using Oracle Text and then use CONTAINS to execute the query
more efficiently:
SELECT falls_name
FROM waterfalls
WHERE
CONTAINS(falls_directions,'mackinac bridge') > 0;
Is this correct? Is there such a thing as a case-insensitive index in
Oracle Text? I did take a quick look at the Oracle Text manual, but
this capability didn't leap out at me. Is "case-insensitive" the term
Oracle Text uses? In any case, I need to verify whether what I've been
told is correct.
Jonathan Gennick --- Brighten the corner where you are
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com *
http://ValleySpur.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jonathan Gennick
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
