here I am giving only where clause. existing where clause is having so many or conditions, can I replace with Case.
Please suggest.
Where
( a = 1 and b=2) or
(a=3 and b=4) or
(a=4 and b=8)
Can replace with
Where
Case
When ( a = 1 and b=2) then " here what should we do"
When (a=3 and b=4) then "here what should we do"
When (a=4 and b=8) then "here what should we do"
Else null ("is it ok"
End is not null
Hari
Please suggest.
Where
( a = 1 and b=2) or
(a=3 and b=4) or
(a=4 and b=8)
Can replace with
Where
Case
When ( a = 1 and b=2) then " here what should we do"
When (a=3 and b=4) then "here what should we do"
When (a=4 and b=8) then "here what should we do"
Else null ("is it ok"
End is not null
Hari