ETL Case and Decode

What is the difference between case and decode?

Showing Answers 1 - 1 of 1 Answers


  • Sep 30th, 2016

CASE can handle the multi return type like if you need the sal between 5000 to 10000 it will handle but in case of DECODE it is not handled. So conclusion is that CASE handles multi return type but DECODE will handle the equal value comparisons.
And CASE is ANSI complaints and DECODE is ORACLE condition

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions