Insights into Statistics, Query Optimization and the Oracle Optimizer

How do I cut and paste commands from your blog?

Maria Colgan
Distinguished Product Manager

At the recent ODTUG  Kscope 12 conference several people told me that they really enjoyed our blog on the Optimizer but were frustrated because they couldn’t cut and paste the commands used in the blog posts straight into their environment.

Typically I use screen shots in the blog posts to make the commands clear but it does mean that it is impossible to cut and paste the commands into your environment. In order to get around this I have created a downloadable .sql script for each of our blog posts. You should now see the sentence “You can get a copy of the script I used to generate this post here”, appearing at the bottom of each blog post. Clicking on the link will open the .sql script that contains all of the commands used in the post. You can either save the entire script or just cut and paste the particular command you are interested in!

I have added scripts for all of this year’s blog posts and am slowly making my way through our old posts until we have a script for everything we have posted to date.

Hopefully this will help!

+Maria Colgan

Join the discussion

Comments ( 2 )
  • joshua Friday, July 6, 2012

    Hi Maria, It looks like the link is broken

  • Maria Colgan Wednesday, July 11, 2012

    Sorry about the broken link in this post. It has been fixed. It is however just an example. The links in the actual posts are all working fine.



Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.