Home » SQL & PL/SQL » SQL & PL/SQL » oracle case insensitivity
oracle case insensitivity [message #230236] Wed, 11 April 2007 04:49 Go to next message
sunsanvin
Messages: 60
Registered: April 2006
Location: Hyderabad
Member

Dear Experts,

the first statement (below) gives us the result. But how can i get the result with the second and third like that?
is there any collation like that or we have to use some functions?

select 'asdfgh' from dual where 'raj'= 'raj'
select 'asdfgh' from dual where 'raj'= 'Raj'
select 'asdfgh' from dual where 'raj'= 'RAJ'

thank you very much
Re: oracle case insensitivity [message #230238 is a reply to message #230236] Wed, 11 April 2007 04:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"where lower(...)=lower(...)"

Regards
Michel
Re: oracle case insensitivity [message #230239 is a reply to message #230236] Wed, 11 April 2007 04:53 Go to previous messageGo to next message
fcatak
Messages: 16
Registered: March 2007
Location: turkey
Junior Member
select 'asdfgh' from dual where lower('raj')= lower('RAJ')


http://fcatak.spaces.msn.com
Re: oracle case insensitivity [message #230396 is a reply to message #230239] Wed, 11 April 2007 15:29 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Or, use OraFAQ Forum's search facility; you'll find something like this; although suggested solutions surely work, you might spend a few moments to check what other people think.
Re: oracle case insensitivity [message #230398 is a reply to message #230396] Wed, 11 April 2007 15:51 Go to previous message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Also look at the following contributed articles:
Previous Topic: Materialized View
Next Topic: working with external file in PL/SQL
Goto Forum:
  


Current Time: Fri Dec 09 17:43:12 CST 2016

Total time taken to generate the page: 0.19604 seconds