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
> Oracle DBA, Vermont Department of Taxes
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
