File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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 Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Database in Jsp" Watch "Database in Jsp" New topic

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

Suresh Velagapudi
Ben Souther

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 - -
I agree. Here's the link:
subject: Database in Jsp
It's not a secret anymore!