Expression Case in SQL for access Oracle

[andresvc]

Hi...

I want to use the expression Case with SQL in the oracle database but I can´t to find the correct form to use it.

Anybody can help me????? or if you know about a link with a very good documentation of that please tell me...

Thanks for your help.

Regards.

 

[ManjulaMadhu]

you can take lead from this example:

select
case when
to_char(sysdate,'D')>'1' and to_char(sysdate,'D')<'7'
then
'Weekday'
else
'Weekend'
end as period_of_week from
dual;

 

[andresvc]

I want to use this Case in DTS of SQL Server and I can´t.

Regards.