Jared, didn't you mean:
select
chr(84)||chr(104)||chr(97)
||chr(110)||chr(107)||chr(32)
||chr(71)||chr(111)||chr(100)
||chr(33)
from dual
Just being picky... :D
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
> -----Original Message-----
> From: Jared Still [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 11, 2002 7:33 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Decode
>
>
>
> 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
> /
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jesse, Rich
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).
