Message-Id: <22541.293635@fatcity.com> From: Jared Still Date: Wed, 11 Sep 2002 16:29:51 -0700 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 / 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