Home » RDBMS Server » Server Administration » How to make oracle database case-insensitive?
How to make oracle database case-insensitive? [message #372098] Wed, 10 January 2001 04:56 Go to next message
Latha.G
Messages: 2
Registered: January 2001
Junior Member
Please reply this as much as possible.i need it urgently.

Report message to a moderator

Re: How to make oracle database case-insensitive? [message #372111 is a reply to message #372098] Wed, 10 January 2001 10:01 Go to previous message
Suresh
Messages: 189
Registered: December 1998
Senior Member
Hi,
Oracle database data is always case sensitive.. If you want to fetch data (both upper and lower case) from database use UPPER or LOWER function.

e.g.

select sno,sname from samp where upper(sname)='XYZ';

If it is not correct solution for your problem,
describe your problem in detail

Suresh Vemulapalli

Report message to a moderator

Previous Topic: Regarding Storage Of Images Into Database
Next Topic: fetching data for a fiscal week of prevoius year
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 18 00:56:08 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.