Case and Decode

Question

How can we covert Case to Decode or Decode to Case?

Priya Linge · Answer

Hi 1.CASE and DECODE are the two widely used constructs in the SQL. And both have the functionality of an IF-THEN-ELSE statement to return some specified value meeting some criteria. Please check below link which will explain the convert case Decode to Case and vice versa. http://www.club-oracle.com/forums/case-and-decode-two-powerfull-constructs-of-sql-t181/ Hope this will help you. Thanks.

Akash Ahlawat · Answer

Thanks Priya..