jQuery in Action, 2nd edition*
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Database in Jsp
 
Similar Threads
Hibernate entity manager: call to find() and showing SQL
using a session value on sql query
Save QueryString as String ?
Hibernate SQL
Log4j Suppress JPA generated SQL