{"id":932,"date":"2005-10-17T12:00:00","date_gmt":"2005-10-17T12:00:00","guid":{"rendered":"http:\/\/orcldoug.com\/blog\/?p=932"},"modified":"2005-10-17T12:00:00","modified_gmt":"2005-10-17T12:00:00","slug":"case-article","status":"publish","type":"post","link":"http:\/\/orcldoug.com\/blog\/2005\/10\/17\/case-article\/","title":{"rendered":"CASE Article"},"content":{"rendered":"

I’ve uploaded the MS Word<\/a> and PDF<\/a> versions of a new paper about CASE expressions, which is really just a replacement for the earlier DECODE paper. This one has been an unexpected trial, probably because it was a bit of a chore that I knew I had to get round to because the DECODE approach is dated.<\/p>\n

I’d like to thank the following people for sparing some of their time to read through the paper, checking it for accuracy and making some very useful suggestions for improvement. As usual, the final decisions and all of the mistakes are mine and there would have been more if it wasn\ufffdt for their efforts. Cheers, guys.<\/p>\n

Andrew Campbell, Sun Microsystems
Colin Garside, BUPA
John Gilroy, Ask Jeeves
Jari Kuhanen, Sun Microsystems<\/b><\/p>\n

If anyone else spots any errors or can suggest how the paper could be improved, feel free to post feedback on the website, post a comment here or drop me an email at dougburns@yahoo.com<\/p>\n","protected":false},"excerpt":{"rendered":"

I’ve uploaded the MS Word and PDF versions of a new paper about CASE expressions, which is really just a replacement for the earlier DECODE paper. This one has been an unexpected trial, probably because it was a bit of a chore that I knew I had to get round to because the DECODE approach… Continue reading CASE Article<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-932","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":939,"url":"http:\/\/orcldoug.com\/blog\/2005\/09\/16\/decode-paper\/","url_meta":{"origin":932,"position":0},"title":"DECODE paper","date":"September 16, 2005","format":false,"excerpt":"Over the past few months I've occasionally pondered what to do about the DECODE paper on this site.On the one hand, it was written 6 years ago when DECODE was more prevalent than CASE so it's out of date.On the other, it's popular and is the main reason by far\u2026","rel":"","context":"With 3 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":925,"url":"http:\/\/orcldoug.com\/blog\/2005\/10\/28\/dbms_xplan-10gr2-autotrace-and-the-case-paper\/","url_meta":{"origin":932,"position":1},"title":"DBMS_XPLAN, 10gR2 Autotrace and the CASE paper","date":"October 28, 2005","format":false,"excerpt":"When I was putting the finishing touches to the CASE paper, Andy Campbell (one of the reviewers) pointed out that he preferred the DBMS_XPLAN output when looking at execution plans for SQL statements. I do too, but I wanted to use Autotrace, partly for consistency with the original DECODE paper,\u2026","rel":"","context":"With 3 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1047,"url":"http:\/\/orcldoug.com\/blog\/2006\/08\/05\/my-most-common-search-words\/","url_meta":{"origin":932,"position":2},"title":"My Most Common Search Words","date":"August 5, 2006","format":false,"excerpt":"The Top 12.36 15.52% animal porn18 7.76% sql decode6 2.59% decode function examples4 1.72% decode syntax3 1.29% px deq credit3 1.29% saved oracle stats3 1.29% oracle table statistics3 1.29% animal porn .com3 1.29% using code decode tables in oracle3 1.29% oracle restore previous statistics cbo2 0.86% select table_name, num_rows2 0.86%\u2026","rel":"","context":"With 6 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1402,"url":"http:\/\/orcldoug.com\/blog\/2008\/04\/17\/mmon-sampling-ash-data\/","url_meta":{"origin":932,"position":3},"title":"MMON Sampling ASH Data","date":"April 17, 2008","format":false,"excerpt":"When I was working on the course, I noticed this White Paper (PDF) on Oracle 10g Self-Management Framework Internals: Exploring the Automatic Workload Repository. The paper describes the way that MMON selects 1 in 10 of the ASH samples for storage in DBA_HIST_ACTIVE_SESS_HISTORY (I suppose it would be more correct\u2026","rel":"","context":"With 4 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1046,"url":"http:\/\/orcldoug.com\/blog\/2006\/08\/05\/statcounter-blocking-cookie\/","url_meta":{"origin":932,"position":4},"title":"Statcounter Blocking Cookie","date":"August 5, 2006","format":false,"excerpt":"My website stats have shot up since making the case, decode and px papers accessible again using server side redirection from the old Tripod site. Spot the bit where the redirections were missing \ud83d\ude09In fairness to Pete S, though, I should point out that the number of page hits is\u2026","rel":"","context":"With 1 comment","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1032,"url":"http:\/\/orcldoug.com\/blog\/2006\/07\/21\/im-no-1-on-msn-search\/","url_meta":{"origin":932,"position":5},"title":"I’m No. 1 on MSN Search!","date":"July 21, 2006","format":false,"excerpt":"For Animal Porn \ud83d\ude41Actually, my stats are looking a lot better since I put the Tripod site back in place with redirection pages to oracledoug.com. A decent percentage of my visits are Google searches for 'SQL decode' and the like, so I'd been missing them ....","rel":"","context":"With 3 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/932","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/comments?post=932"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/932\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=932"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=932"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=932"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}