Home » Other » Client Tools » select in a decode
select in a decode [message #38563] Fri, 26 April 2002 17:30 Go to next message
Manish
Messages: 79
Registered: December 2000
Member
Hi ,
Can i have a select statement in a decode clause?
somethig like

select DECODE((select 1 from dual),1,'good','bad')
from dual;

i am getting the error
ORA-00937: not a single-group group function

cud neone give some insight
thanks
Manish
Re: select in a decode [message #38566 is a reply to message #38563] Fri, 26 April 2002 20:29 Go to previous messageGo to next message
Saga
Messages: 51
Registered: April 2002
Member

I tried ur query it works fine.
Re: select in a decode [message #38594 is a reply to message #38563] Mon, 29 April 2002 10:09 Go to previous messageGo to next message
Manish
Messages: 79
Registered: December 2000
Member
bUT IT DIDN'T WORK FINE IN MY CASE.
ANY IDEAS WHY?
Re: select in a decode [message #38613 is a reply to message #38563] Tue, 30 April 2002 07:13 Go to previous messageGo to next message
oraboy
Messages: 97
Registered: October 2001
Member
check out your version..I think select inside decode is allowed only in 8i
Re: select in a decode [message #38627 is a reply to message #38563] Wed, 01 May 2002 08:56 Go to previous messageGo to next message
Manish
Messages: 79
Registered: December 2000
Member
i HAVE 8.1.7 ... SO I GUESS THIS SHUD HAVE WORK!!
Re: select in a decode [message #38629 is a reply to message #38627] Wed, 01 May 2002 10:21 Go to previous message
oraboy
Messages: 97
Registered: October 2001
Member
Def'tly. Becoz I checked it even in 8.1.6 and it works .
I have no idea why it doesnt work for you!

check ur client (SQL+) version too.

Regards
Oraboy
Previous Topic: URGENT - Error while executing package procedure
Next Topic: Why doesn't this work ?
Goto Forum:
  


Current Time: Fri Mar 29 10:59:08 CDT 2024