case, nvl and datetime fields
From: bon <magicrat880_at_hotmail.com>
Date: 9 Dec 2003 10:02:52 -0800
Message-ID: <c7986eaf.0312091002.51327b57_at_posting.google.com>
Date: 9 Dec 2003 10:02:52 -0800
Message-ID: <c7986eaf.0312091002.51327b57_at_posting.google.com>
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?