Register / Login
EJB and other Java EE Technologies
Convert this SQL to EJB QL
posted 6 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 '%'
Boost this thread!
Search Query Problem
Java Persistence QL
Best way of learning EJB and EJB-QL!
SQL and EJB-QL