| How to set oracle case insensitive as default [message #134996] |
Mon, 29 August 2005 06:17  |
genialsenthil
Messages: 26
Registered: June 2005
Location: Chennai
|
Junior Member |
|
|
Hi,
I am using oracle 10g as my database. I want to set oracle case sensitive to case insensitive. I have tried out in oracle "Alter session" command. It is also not working. I need case insensitive is default for all users not for single user and session....
I don't want to use queries like these in "Sql Select Query". If give select statement as "Select * from emp Where ename like 'a%'" as a input query. I need the result set as "name" starting with "A" and as well as "a"....
Could you please help me.........
Let me know what is the procedure to follow to make the oracle database as default case insensitive.....
With Thankz & Expectations,
Senthil Kumar.
|
|
|
|
| Re: How to set oracle case insensitive as default [message #135006 is a reply to message #134996] |
Mon, 29 August 2005 06:53  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
SCOTT@teng>ALTER SESSION SET NLS_COMP=ANSI;
Session altered.
SCOTT@teng>ALTER SESSION SET NLS_SORT=GENERIC_BASELETTER;
Session altered.
SCOTT@teng>update emp set ename='smith' where job='PRESIDENT';
1 row updated.
SCOTT@teng>commit;
Commit complete.
SCOTT@teng>select * from emp where ename='smith';
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ---------- --------- ---------- --------- ---------- ---------- ----------
7369 SMITH CLERK 7902 17-DEC-80 800 20
7839 smith PRESIDENT 17-NOV-81 5000 10
Just a quick note:
setting this in database wide may not be very desirable in certain situation. Please test and set it only to your application!.
[Updated on: Mon, 29 August 2005 07:21] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
