Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> create index with lowercase
hello together,
we are having a field "name" in our table. Now we want to seach not case-sensitive. If we use lowercase of the field and the searchstring, the database uses full-table-scan. Is it possible to use the function lowercase (?) in an index on field "name"? We must support ORACLE 7.3 till 9.x.
thank you
Jörg Received on Wed Oct 30 2002 - 04:03:15 CST