1. How to simulate NVL in HQL    stackoverflow.com

I tried this:

from Table where (:par1 is null or col1 = :par1)
but it happens that
from Table where :par1 is null
always returns all the rows of the table, even if the :par1 ...

2. Can I use NVL in hql?    forum.hibernate.org

3. nvl function in hql    forum.hibernate.org

hi friends, We r wokring on projects where we support two db. Nowmy question is how can i use nvl or coalesce function alternatively so that it wont break my code.Is there any way this function can be used or there are any separate function can be used to satisfy need for both db. We r using oracle 9 and sql ...