[hibernate-dev] case, coalesce, nullif; but no NVL/ISNULL

Steve Ebersole steve at hibernate.org
Fri Feb 3 10:46:50 EST 2012

You can use coalesce to achieve the same.  Maybe thats the standard 

On Fri 03 Feb 2012 09:40:37 AM CST, Steve Ebersole wrote:
> HQL and JPQL define support for case expressions (both simple and 
> searched), as well as the 2 "abbreviated" SQL CASE forms nullif and 
> coalesce.
> However, we do not currently have a standard form for NVL/ISNULL. Part 
> of the problem is that SQL does not define such an abbreviated form 
> either. And while most vendors have such an abbreviated form, they are 
> all named something different, NVL and ISNULL being the 2 I am 
> familiar with.
> But its such a generally useful construct, I wonder if we should 
> define support for it in the base Dialect as well. Not sure which name 
> to use tbh. NVL is a bit obtuse, ISNULL sounds more like a function 
> returning a boolean.
> Thoughts?

steve at hibernate.org

More information about the hibernate-dev mailing list