A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Murach's Java Servlets and JSP
this week in the
EJB and other Java EE Technologies
Convert this SQL to EJB QL
Joined: Nov 24, 2008
Jul 06, 2010 13:18:49
Hi can anyone help me out in converting the following SQL query to
QL, the following nvl fuction is not valid for EJB QL and i am searching for an equivalent function that work in EJB QL.
select * from table1 where primarycolumn like '123%' and nvl(column2, '###') like '%'
I agree. Here's the link:
subject: Convert this SQL to EJB QL
Best way of learning EJB and EJB-QL!
Java Persistence QL
Search Query Problem
SQL and EJB-QL
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014