Newsgroups: comp.databases.oracle.server
Subject: Re: Case insensitive searching
Keywords: Case insensitive
References: <5j1uce$re8$1@gruvel.une.edu.au>

cmunday@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:                    <->
<->                                                               <->
<->              www.arikaplan.com                                <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Back to Ari Kaplan's Home Page ack to Ari Kaplan's Home Page