In article <1006364515.409254_at_basic.maxnet.ru>, "AuRoom says...
>
>Hello ALL!
>
>Can anybody help me.
>I have the problem with the SELECT .. WHERE.
>I want to know is there a database option that can set CASE (IN)SENSITIVE
>for WHERE condition for string comparison
>
>Thanks
>
>Konstantin
>
>
we do that with function based indexes, see
http://osi.oracle.com/~tkyte/article1/index.html
for an example.
--
Thomas Kyte (tkyte@us.oracle.com) http://asktom.oracle.com/
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/
Opinions are mine and do not necessarily reflect those of Oracle Corp
Received on Wed Nov 21 2001 - 12:09:06 CST
