Re: case, nvl and datetime fields

From: VC <>
Date: Tue, 09 Dec 2003 18:23:19 GMT
Message-ID: <rqoBb.347574$ao4.1164423_at_attbi_s51>


DECODE(loandate, null, 'N', 'Y')


case when loandate is null then 'N' else 'Y' end


"bon" <> 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

Original text of this message