Re: case, nvl and datetime fields
From: VC <boston103_at_hotmail.com>
Date: Tue, 09 Dec 2003 18:23:19 GMT
Message-ID: <rqoBb.347574$ao4.1164423_at_attbi_s51>
Date: Tue, 09 Dec 2003 18:23:19 GMT
Message-ID: <rqoBb.347574$ao4.1164423_at_attbi_s51>
Hello,
DECODE(loandate, null, 'N', 'Y')
..or
case when loandate is null then 'N' else 'Y' end
Rgds.
"bon" <magicrat880_at_hotmail.com> wrote in message
> I have a mssql view I am translating to oracle syntax
>
> One of the lines in the mssql view is like this:
> DATO=CASE (isnull(loandate,1)) WHEN 1 THEN 'N' ELSE 'Y' END
>
> In other words, the view will return a Y if loandate has a value, N if
> it does not have a value
>
> How can I accomplish the same with Oracle9?
Received on Tue Dec 09 2003 - 19:23:19 CET