How to make case insensitivity work in Oracle SQL Developer

Applies to:
Oracle SQL Developer - Version: 1.1.2.25 to 1.5.3.57.83
Information in this document applies to any platform.
Goal
How to make case insensitivity work in Oracle SQL Developer
Solution

1. Connect to the Scott schema using Oracle SQL Developer.

2. Run the below SQL Queries.

SQL> SELECT * FROM emp WHERE ename='james';
No rows selected.
SQL>SELECT * FROM emp WHERE ename='JAMES';
This will give the result set which are available in the EMP table.

3. Now alter the below session parameters

ALTER SESSION SET NLS_COMP=ANSI;
ALTER SESSION SET NLS_SORT='BINARY_CI';

4. Repeat the Step 2,You will get values for both the SQL Queries.
Keywords
CONFIGURATION ; SESSION~PARAMETERS ; NLS_COMP=ANSI ; NLS_SORT='BINARY_CI' ;