OraFAQ Forum: Client Tools » select in a decode

Home » Other » Client Tools » select in a decode

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: select in a decode [message #38566 is a reply to message #38563]

Fri, 26 April 2002 20:29

Saga
Messages: 51
Registered: April 2002

Member

I tried ur query it works fine.

Report message to a moderator

Re: select in a decode [message #38594 is a reply to message #38563]

Mon, 29 April 2002 10:09

Manish
Messages: 79
Registered: December 2000

Member

bUT IT DIDN'T WORK FINE IN MY CASE.
ANY IDEAS WHY?

Report message to a moderator

Re: select in a decode [message #38613 is a reply to message #38563]

Tue, 30 April 2002 07:13

oraboy
Messages: 97
Registered: October 2001

Member

check out your version..I think select inside decode is allowed only in 8i

Report message to a moderator

Re: select in a decode [message #38627 is a reply to message #38563]

Wed, 01 May 2002 08:56

Manish
Messages: 79
Registered: December 2000

Member

i HAVE 8.1.7 ... SO I GUESS THIS SHUD HAVE WORK!!

Report message to a moderator

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 07:44:50 CDT 2025