How to Use Decode function in HQL

Ashish Jha · **Joined:** Fri Mar 18, 2005 8:54 am **Posts:** 4

Read the rules before posting!
http://www.hibernate.org/ForumMailingli ... AskForHelp

I have created Reports in PDF by java using jdbc and oracle 9i.
for that I have written a sql containg decode funtion.

Now I have to do that using Hibernate 3.
Is there any function corresponding to decode function in SQL in Hibernate Query Language.

david · **Posted:** Sat Mar 19, 2005 12:16 am

Look into the Dialects which have the Dialect specific db functions supported.
The answer is, in general, no its not supported. Looking at the Oracle dialect I can see, not suprisingly, it is not supported.

snpesnpe · **Joined:** Sat Jun 12, 2004 4:49 pm **Posts:** 915

decode function work in formula
Is is hard implement because decode return different result, but formula can help (maybe)