Register / Login
File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
Win a copy of
Clojure in Action
this week in the
EJB and other Java EE Technologies
Convert this SQL to EJB QL
posted 5 years ago
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:
Search Query Problem
Java Persistence QL
Best way of learning EJB and EJB-QL!
SQL and EJB-QL