Hibernate Community • View topic - Support for DECODE function in HQL

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Support for DECODE function in HQL

Page 1 of 1

[ 4 posts ]

Previous topic | Next topic

Author

Message

sudhir0104

Post subject: Support for DECODE function in HQL

Posted: Tue Jul 11, 2006 3:11 am

Regular

Joined: Mon May 08, 2006 6:00 am
Posts: 53
Location: India

Hi I am trying to use decode function in following HQL, I am getting exception while running this query

select sum(DECODE(tran.strReceiptReq,'Required',1, 0)) as Receipts from Table tran

any idea, whether its supported in HQL ?

I am using Hibernate 3 and I am using oracle9dialect

Thanks

Sudhir

Top

sudhir0104

Post subject:

Posted: Wed Jul 12, 2006 1:28 am

Regular

Joined: Mon May 08, 2006 6:00 am
Posts: 53
Location: India

Any one clue on this ? I am still awaiting some details on this

Sudhir

Top

jiteshks

Post subject:

Posted: Mon Dec 04, 2006 3:42 pm

Newbie

Joined: Sun Nov 19, 2006 6:55 pm
Posts: 9

You will need to put double quote inside decode function...that is for sure.And the type of the column tran.strReceiptReq should be string in hbm.xml .

Top

codecln

Post subject: NVL or Decode functions in HQL

Posted: Wed Mar 05, 2008 10:58 am

Newbie

Joined: Sat Feb 23, 2008 10:20 am
Posts: 1
Location: India

Hi,
How can I call NVL and Decode functions for non String values. Please can you reply to me asap.
With Regards
Pugazh

Top

Page 1 of 1

[ 4 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum