How To Perform Case-Insensitive Queries in SQL Developer (Doc ID 2115286.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle SQL Developer - Version 4.0.3 and later
Information in this document applies to any platform.

Goal

We have a need to allow end users to submit case-insensitive queries.

For example, given the following table:

TABLE:  CASE_TEST
ID VAL1BIG VAL2SMALL
A VALUEA valuea
B VALUEB valueb
C VALUEC valuec

 

 

 

 

 


...we would like the following query to return all the values for ROW ID "A":

Desired Result:

I VAL1BIG              VAL2SMALL          
- -------------------- --------------------
A VALUEA               valuea            

 How can this be done in SQL Developer?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms