Re: Decode

From: Jared Still <jkstill_at_cybcon.com>
Date: Wed, 11 Sep 2002 16:29:51 -0700
Message-Id: <22541.293635@fatcity.com>

No, I didn't know that.

Interesting:

select decode (

   (select to_char(sysdate, 'DAY') from dual),

   'MONDAY','Groan...',
   'TUESDAY','Another day, another dollar',
   'WEDNESDAY','Hump Day',
   'THURSDAY','Let me out of here!',
   'FRIDAY',(
      select
         chr(84)||chr(104)||chr(97)
         ||chr(110)||chr(107)||chr(32)
         ||chr(103)||chr(111)||chr(100)
         ||chr(33)
         from dual
      ),

   'SATURDAY','Sleeping in',
   'SUNDAY','Gone fishing'
)
from dual
/

Jared

On Wednesday 11 September 2002 12:33, Fink, Dan wrote:
> DECODE(expression,
> value1, return1,
> value2, return2,
> ....
> default_return)

>

> BTW, did you know that expression, value, return and default_return can all
> be scalar subqueries?

>

> Dan

>

> -----Original Message-----
> Sent: Wednesday, September 11, 2002 12:59 PM
> To: Multiple recipients of list ORACLE-L

>
>

> Hello everyone,

>

> I am having a senior moment and I have forgetten the syntax for 'decode'.
> Can anyone give me a hint. I have leant out my sql books and of course I
> need them now.

>

> Thanks in advance,
> Ruth Gramolini
Received on Wed Sep 11 2002 - 18:29:51 CDT