{"id":1047,"date":"2006-08-05T12:00:00","date_gmt":"2006-08-05T12:00:00","guid":{"rendered":"http:\/\/orcldoug.com\/blog\/?p=1047"},"modified":"2006-08-05T12:00:00","modified_gmt":"2006-08-05T12:00:00","slug":"my-most-common-search-words","status":"publish","type":"post","link":"http:\/\/orcldoug.com\/blog\/2006\/08\/05\/my-most-common-search-words\/","title":{"rendered":"My Most Common Search Words"},"content":{"rendered":"<p>The Top 12.<\/p>\n<pre><code>36  15.52%    animal porn<br\/>18   7.76%    sql decode<br\/>6    2.59%    decode function examples<br\/>4    1.72%    decode syntax<br\/>3    1.29%    px deq credit<br\/>3    1.29%    saved oracle stats<br\/>3    1.29%    oracle table statistics<br\/>3    1.29%    animal porn .com<br\/>3    1.29%    using code decode tables in oracle<br\/>3    1.29%    oracle restore previous statistics cbo<br\/>2    0.86%    select table_name, num_rows<br\/>2    0.86%    porn<\/code><\/pre>\n<p>I don&#8217;t know whether to laugh or cry &#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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% porn I don&#8217;t know&hellip; <a class=\"more-link\" href=\"http:\/\/orcldoug.com\/blog\/2006\/08\/05\/my-most-common-search-words\/\">Continue reading <span class=\"screen-reader-text\">My Most Common Search Words<\/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-1047","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":1047,"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":1046,"url":"http:\/\/orcldoug.com\/blog\/2006\/08\/05\/statcounter-blocking-cookie\/","url_meta":{"origin":1047,"position":1},"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":1030,"url":"http:\/\/orcldoug.com\/blog\/2006\/07\/21\/monitoring-index-usage\/","url_meta":{"origin":1047,"position":2},"title":"Monitoring Index Usage","date":"July 21, 2006","format":false,"excerpt":"A common requirement cropped up this week. A new Data Warehouse has just gone live and is still in the 'do we have the right indexes here' phase. In this case, the suspicion is that there are too many indexes in a specific schema and that a number of them\u2026","rel":"","context":"With 8 comments","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":1047,"position":3},"title":"I&#8217;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":[]},{"id":932,"url":"http:\/\/orcldoug.com\/blog\/2005\/10\/17\/case-article\/","url_meta":{"origin":1047,"position":4},"title":"CASE Article","date":"October 17, 2005","format":false,"excerpt":"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\u2026","rel":"","context":"With 6 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1056,"url":"http:\/\/orcldoug.com\/blog\/2006\/08\/19\/ausougoaug-2006-conference-announcement\/","url_meta":{"origin":1047,"position":5},"title":"AUSOUG\/OAUG 2006 Conference Announcement","date":"August 19, 2006","format":false,"excerpt":"The AUSOUG and OAUG committees are very excited to announce the Australian 2006 conference series is less than three months away. While our American neighbours are focusing on Oracle OpenWorld in October, and our UKOUG friends on their (extended!) November conference, Australians will not miss out with the largest Oracle\u2026","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1047","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=1047"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1047\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=1047"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=1047"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=1047"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}