Re: Case insensitive searching

cmunday_at_neumann.une.edu.au (Craig Munday) writes:

>Being a DBA currently moving our systems from Sybase to Oracle I have a newbie
>question concerning sort ordered.
>Is it possible to configure an Oracle Database/Instance with a case
>insensitive sort order?
>Your help would be much appreciated.

Craig,

Making a search case insensitive is done on a search-by-search basis and cannot be configured Instance-wide.

To make a search ("query") case-insensitive, use the UPPER function. For example,

SELECT * FROM EMPLOYEES WHERE UPPER(EMPLOYEE_NAME)='LARRY ELLISON'; To order the results of a query regardless of the case, also use the UPPER function:

SELECT * FROM EMPLOYEES ORDER BY UPPER(EMPLOYEE_NAME); -Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 50+ technical tips, visit my Web Page:                    <->
<->                                                               <->
<->              http://homepage.interaccess.com/~akaplan         <->
<->                                                               <->
<->             email: akaplan_at_interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->