aspose file tools*
The moose likes JDBC and the fly likes Database in Jsp Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Database in Jsp" Watch "Database in Jsp" New topic
Author

Database in Jsp

velgapudi suresh
Ranch Hand

Joined: Aug 11, 2006
Posts: 32
Hi All,

I have small problem. In SQL how v can retrive the characters without case sensitiveness in Oracle 10g.
my sql is : select name from emp where name like'w%';

but i want upper value and lower value....


anybody help me to solve

Thnks
Suresh Velagapudi
Ben Souther
Sheriff

Joined: Dec 11, 2004
Posts: 13410

Moving to our JDBC forum (which is the best place for a question like this).


Java API J2EE API Servlet Spec JSP Spec How to ask a question... Simple Servlet Examples jsonf
Renato Losio
Ranch Hand

Joined: Nov 23, 2005
Posts: 99
You may do something like:

select name from emp where upper(name) like'W%';

but watch out for performances as you won't use any index defined on the name column.


Renato Losio - www.arsenio.it - renatoweb@arsenio.it
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Database in Jsp