Case Sensitiveness

Oracle maintains the case sensitiveness by default .To make the queries , we would need to change the NLS settings to enforce case insenstiveness .

Here is an example ….

Get Zahir Mohideen’s stories in your inbox

Join Medium for free to get updates from this writer.

Remember me for faster sign in

Note : As usual , please regression test your application before making these changes

SQL> alter session set nls_sort = binary_ci; 
 Session altered.

SQL> select * from scott.emp where ename like ‘smith’; 

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
 7369 SMITH CLERK 7902 17-DEC-80 800 20

SQL> select * from scott.emp where ename like 'sMith';

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO 
 7369 SMITH CLERK 7902 17-DEC-80 800 20

SQL> select * from scott.emp where ename like ‘SMITH’; 
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
 7369 SMITH CLERK 7902 17-DEC-80 800 20

Originally published at https://zahirmohideen.blogspot.com/2010/04/case-sensitiveness.html