Home » Other » General » oracle 9i case sensitive
oracle 9i case sensitive [message #205723] Mon, 27 November 2006 04:34 Go to next message
sunsanvin
Messages: 60
Registered: April 2006
Location: Hyderabad
Member

dear friends,
is it possible to make oracle 9i statements make case sensitive?
i read one article, in that it is possible for oracle 10g.
what about oracle 9i?


guide me in this regard
thank you very much
Re: oracle 9i case sensitive [message #205766 is a reply to message #205723] Mon, 27 November 2006 08:13 Go to previous messageGo to next message
Cthulhu
Messages: 381
Registered: September 2006
Location: UK
Senior Member
You mean you want "SELECT" to have a different meaning to "select" or "Select" ? What would the difference be exactly ?

The only place you can introduce case sensitivity is in table and column names. If you can be bothered to going to the trouble of surrounding all names with double quotation marks, you can have case sensitive names e.g.

create table "MyTable" ("MyColumn" varchar2(10),...)

However, you will have to put the double quotes round the name every time you want to use it from now on. If you just say

select * from MyTable

it will be converted to "MYTABLE" and won't work. You would have to do:

select * from "MyTable"

Re: oracle 9i case sensitive [message #206169 is a reply to message #205723] Wed, 29 November 2006 00:47 Go to previous messageGo to next message
sunsanvin
Messages: 60
Registered: April 2006
Location: Hyderabad
Member

what i mean to say is
oracle 9i some times behaving like case sensitive in data retireval.
how can i avoid this situations?
is there any collation settings for this?
Re: oracle 9i case sensitive [message #206180 is a reply to message #206169] Wed, 29 November 2006 01:35 Go to previous messageGo to next message
Littlefoot
Messages: 20890
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Is this what you have in mind?
Connected to:
Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production

SQL> create table brisime (col varchar2(20));

Table created.

SQL> insert into brisime values ('Little Foot');

1 row created.

SQL> insert into brisime values ('LITTLE foot');

1 row created.

SQL> insert into brisime values ('little FOOT');

1 row created.

SQL> select * from brisime;

COL
--------------------
Little Foot
LITTLE foot
little FOOT

SQL> alter session set nls_comp = ANSI;

Session altered.

SQL> alter session set nls_sort = GENERIC_BASELETTER;

Session altered.

SQL> select * from brisime where col = 'little foot';

COL
--------------------
Little Foot
LITTLE foot
little FOOT

SQL>
Re: oracle 9i case sensitive [message #206183 is a reply to message #206180] Wed, 29 November 2006 01:49 Go to previous messageGo to next message
sunsanvin
Messages: 60
Registered: April 2006
Location: Hyderabad
Member

It is great littlefoot

thank you very much,

but how can change this session everytime?


i sold my product to my client, and internally how this can be set inside oracle?


what i mean to say is........

is there any possible way in oracle 9i to make retrieval permantly case-in-sensitive?


please help me in this regard
Re: oracle 9i case sensitive [message #206187 is a reply to message #206183] Wed, 29 November 2006 02:02 Go to previous messageGo to next message
Littlefoot
Messages: 20890
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Yes, using the LOGON trigger.

Check this Ask Tom discussion; you'll also find some examples there.
Re: oracle 9i case sensitive [message #206190 is a reply to message #206187] Wed, 29 November 2006 02:07 Go to previous message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Also look at these articles on this site:

- 10gR2 New Feature: Case Insensitive Sorts & Compares by Natalka Roshak

- 10gR2 New Feature: Case Insensitive Searches by James Koopman
Previous Topic: Hash_join_enabled in 10g
Next Topic: SPOOL table structure from FOXPRO
Goto Forum:
  


Current Time: Sat Dec 03 13:46:35 CST 2016

Total time taken to generate the page: 0.05255 seconds