Well, if we're going to be picky :)
select chr(84)||chr(104)||chr(97)
||chr(110)||chr(107)||chr(32)
||chr(71)||chr(111)||chr(100)
||chr(101)||chr(115)||chr(115)
||chr(33)
from dual
>
> 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
> Rich.Jesse_at_qtiworld.com Quad/Tech International, Sussex, WI USA
>
>
> > -----Original Message-----
> > From: Jared Still [mailto:jkstill_at_cybcon.com]
> > 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: <a
href="
http://mail.thirdparadigm.com//jump/http://www.orafaq.com">
http://www.orafaq.com</a>
> --
> Author: Jesse, Rich
> INET: Rich.Jesse_at_qtiworld.com
>
> 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: ListGuru_at_fatcity.com (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).
Christopher Beckley
ThirdParadigm LLC
cbeckley_at_thirdparadigm.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: cbeckley_at_thirdparadigm.com
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: ListGuru_at_fatcity.com (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).
Received on Thu Sep 12 2002 - 15:33:25 CDT
