select in a decode [message #38563] |
Fri, 26 April 2002 17:30 |
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 #38629 is a reply to message #38627] |
Wed, 01 May 2002 10:21 |
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
|
|
|