{"id":1084,"date":"2006-09-17T12:00:00","date_gmt":"2006-09-17T12:00:00","guid":{"rendered":"http:\/\/orcldoug.com\/blog\/?p=1084"},"modified":"2006-09-17T12:00:00","modified_gmt":"2006-09-17T12:00:00","slug":"test-code-examples","status":"publish","type":"post","link":"http:\/\/orcldoug.com\/blog\/2006\/09\/17\/test-code-examples\/","title":{"rendered":"Test Code Examples"},"content":{"rendered":"

Here’s a code example with <pre> tags around it. There should be extra spacing between the query and the result than the two lines of the query.<\/p>\n

SELECT 'Spiders are deadly'FROM DUAL;Spiders are deadly<\/pre>\n
And here is the entire HTML fragment from above <\/p>\n
<p>Here’s a code example with <pre> tags around it. There should be extra spacing between the query and the result than the two lines of the query.<\/p><pre>SELECT ‘Spiders are deadly'<br \/>FROM DUAL;<br \/><br \/>Spiders are deadly<\/pre><p><br \/> <\/p><p \/><\/p>\n
And here’s a try without using line breaks at all, but having them in the text itself<\/p>\n
SELECT 'Spiders are deadly'\nFROM DUAL;\n\nSpiders are deadly\n<\/pre>\n
Which I now realise is the way to go. It’ll just mean me switching back and forwards between wysiwyg editing and the HTML window. Not too hard but I won’t be fixing up all of the old blogs<\/p>\n","protected":false},"excerpt":{"rendered":"
Here’s a code example with <pre> tags around it. There should be extra spacing between the query and the result than the two lines of the query. SELECT ‘Spiders are deadly’FROM DUAL;Spiders are deadly And here is the entire HTML fragment from above <p>Here’s a code example with <pre> tags around it. There should be… Continue reading Test Code Examples<\/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-1084","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1023,"url":"http:\/\/orcldoug.com\/blog\/2006\/07\/15\/i-dont-want-to-see-html-for-a-long-time\/","url_meta":{"origin":1084,"position":0},"title":"I don’t want to see HTML for a long time","date":"July 15, 2006","format":false,"excerpt":"If I'm honest, I'm sure most of my problems have been self-inflicted and my 'solution' is little more than an unsatisfactory hack but if it means I don't have to look at any HTML for a few weeks, it will do.I eventually tracked down this problem to a difference between\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1022,"url":"http:\/\/orcldoug.com\/blog\/2006\/07\/14\/grrrrrr\/","url_meta":{"origin":1084,"position":1},"title":"Grrrrrr!","date":"July 14, 2006","format":false,"excerpt":"So what can I do? I've messed around with templates, updated the back-end database and I'm going round in circles.My problem? Well 
 tags are what I'm looking for so that the output of queries are spaced correctly, but IE doesn't like 
 tags inside 
 tags and ignores them.\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1231,"url":"http:\/\/orcldoug.com\/blog\/2007\/03\/10\/how-can-i-tell-the-actual-dop-used-for-my-parallel-query\/","url_meta":{"origin":1084,"position":2},"title":"How can I tell the actual DOP used for my Parallel Query?","date":"March 10, 2007","format":false,"excerpt":"At the end of my presentation this week, when I asked for questions, a lady from the middle of the hall piped up to ask something along the lines of.\"How can I tell the actual DOP used for my Parallel Query?\" (or words to that effect)It was in the context\u2026","rel":"","context":"With 3 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":868,"url":"http:\/\/orcldoug.com\/blog\/2006\/02\/05\/we-never-learn-do-we\/","url_meta":{"origin":1084,"position":3},"title":"We Never Learn, Do We?","date":"February 5, 2006","format":false,"excerpt":"I had an interesting day at work yesterday. We've run into major performance problems when upgrading a number of Production databases from 8i to 9i. How could that happen, when we've performed regression tests to ensure that the applications perform as well as or better than they did on 8i?Probably\u2026","rel":"","context":"With 5 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1505,"url":"http:\/\/orcldoug.com\/blog\/2009\/07\/02\/session-level-ash-reports\/","url_meta":{"origin":1084,"position":4},"title":"Session Level ASH Reports","date":"July 2, 2009","format":false,"excerpt":"Some features in this post require a Diagnostics Pack license.I noticed a post on H.Tongu\u00e7 Y\u0131lmaz's blog about filtering ASH data to look at the actions of a specific instrumented query. There are a few strange things that I was going to comment on but the blog requires me to\u2026","rel":"","context":"With 1 comment","img":{"alt_text":"","src":"https:\/\/i0.wp.com\/18.133.199.212\/wp-content\/uploads\/recovered\/ash_report.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1363,"url":"http:\/\/orcldoug.com\/blog\/2007\/12\/04\/murali-vallath\/","url_meta":{"origin":1084,"position":5},"title":"Murali Vallath","date":"December 4, 2007","format":false,"excerpt":"When I blogged about Openworld, I decided not to mention one presentation at the time. I attended Murali Vallath's \"Oracle Parallel Query Feature in a RAC environment\" on Sunday afternoon. I almost didn't because I know the subject pretty well, but I thought I might learn something or see a\u2026","rel":"","context":"With 42 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1084","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=1084"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1084\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=1084"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=1084"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=1084"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}