Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Replace CASE with DECODE

653402Oct 17 2008 — edited Oct 17 2008
Guys,

I want to replace CASE statement with DECODE. How ?

case when msg.is_swap = 'Y' and msg.buy_sell = 1 then 'SO'
when msg.is_swap = 'Y' and msg.buy_sell = 0 then 'SI'
else ''
end As TransactionType



How should i implement DECODE function to do the above one ?

Regards
Karthik
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 14 2008
Added on Oct 17 2008
7 comments
1,173 views