My Oracle Support Banner

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

Last updated on NOVEMBER 30, 2019

Applies to:

Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle SQL Developer - Version 4.0.3 and later
Oracle Cloud Infrastructure - Database Service - Version N/A 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

To view full details, sign in with your My Oracle Support account.

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

In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.