A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Database in Jsp
Joined: Aug 11, 2006
Aug 11, 2006 04:01:00
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
Joined: Dec 11, 2004
Aug 11, 2006 04:43:00
Moving to our
forum (which is the best place for a question like this).
How to ask a question...
Simple Servlet Examples
Joined: Nov 23, 2005
Aug 11, 2006 04:51:00
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 -
I agree. Here's the link:
subject: Database in Jsp
Log4j Suppress JPA generated SQL
Hibernate entity manager: call to find() and showing SQL
using a session value on sql query
Save QueryString as String ?
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014