Decode or case which is faster

Choose your interests Get the latest news, expert insights and market research, sent straight to your inbox. Newsletter Topics Select minimum 1 topic. Hi a Can anyone please tell me what is the difference between case and decode? Narsimha Bandaru Posted October 26, 0 Comments. Manish Nevrekar Posted October 28, 0 Comments.

Monty Latiolais Posted October 28, 0 Comments. Rick Wery Posted October 28, 0 Comments. Anonymous Posted October 13, 0 Comments. Yes case is faster than decode. Register or Login.

Welcome back! Reset Your Password We'll send an email with a link to reset your password. Stay ahead! Get the latest news, expert insights and market research, tailored to your interests.

While the decode operator has been around since the earliest days of Oracle, the case operator was introduced in Oracle 8. While d3code and case can be used interchangeably, the decode is more powerful because decode can change SQL results.

See my notes on the decode function. The case statement is used for conditional power in SQL statements. See my notes on the case clause. Oracle Training from Don Burleson The best on site " Oracle training classes " are just a phone call away! You can get personalized Oracle training by Donald Burleson, right at your shop! Burleson is the American Team Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.

We have limited functionality in decode as the decode function only uses the scalar values. Oracle overcomes this in case statement and case statement can work with the sub-queries as well as searchable values. You always need to use it in select statement. You can also use the Case.. When statement in procedure calling. The decode statement will give the error when you use it in procedure calls. I hope you like this detailed level article; If you like this article or if you have any comments kindly comment in comments section.