Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Decode

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US