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!

Decode Vs Case: context switching?

523861Feb 20 2008 — edited Feb 20 2008

So I was told recently that among other reasons, CASE is "better" than Decode in SQL statements because Decode context switches to PL/SQL to perform the checks.

I can't find anything in the documentation to support this.

this site here:
http://www.dba-oracle.com/oracle_news/2005_11_23_case_decode_machinations.htm

mentions that one of the disadvantages of decode is that it's post-retrieval, but it also seems to mention that so is CASE.

anyone have any idea where someone may have got the "context switching" idea from?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 19 2008

Added on Feb 20 2008

6 comments

1,049 views