case, nvl and datetime fields

[bon]

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?

[VC]

Hello,

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

...or

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

Rgds.
"bon" <ma*********@hotmail.com> wrote in message
news:c7**************************@posting.google.c om...

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?

[bon]

"VC" <bo*******@hotmail.com> wrote in message news:<rqoBb.347574$ao4.1164423@attbi_s51>...

Hello,

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

..or

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

Rgds.

Thanks

I actually did find out a way to do it eventually, but unlike you I
complicated it more than necessary...
(if you are good at reading between the lines, you probably realize
now my real problem was with conflicting data types in my original
attempt to translate it)

CASE nvl(loandate,to_date(NULL)) WHEN to_date(NULL) THEN 'N' ELSE 'Y'
END