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

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Default Return

Re: SQL Default Return

From: Oradba Linux <oradba_linux_at_attbi.com>
Date: Wed, 26 Feb 2003 02:38:17 GMT
Message-ID: <pan.2003.02.26.02.42.17.123873@attbi.com>


On Wed, 26 Feb 2003 11:44:46 +1100, abc wrote:

> Hi,
>
> I have a simple SQL
>
> SELECT DECODE(a.date, NULL, 'Date Not Exists', a.date) as Date
> FROM CALENDAR WHERE date = '01-JAN-2003'
>
> '01-JAN-2003' is not in CALENDAR Table then I must expect a
> Default return as 'Date Not Exists'. But that doesn't work.
>
> Anyone knows how to get this Default Return if No rows return.
>
> Thanks

try with trunc(date) Received on Tue Feb 25 2003 - 20:38:17 CST

Original text of this message

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