title: How to use custom code snippets in Toad for Oracle?
body: <p>I'm using Toad for Oracle for accessing Oracle databases. Is there a possibility to invoke custom scripts from Toad so that you don't always have to type these from scratch? E.g. I would like to create custom script</p>
  
  <pre><code>select count(*) as cnt
  from 
  </code></pre>
  
  <p>and invoke this using custom text like</p>
  
  <pre><code>scf
  </code></pre>
  
  <p>This kind of functionality is found e.g in <a href="http://www.red-gate.com/products/sql-development/sql-prompt/" rel="nofollow">Redgate's SQL Prompt</a>:</p>
  
  <blockquote>
    <p>It doesn't tell you how you should write code, either. You can tell
    SQL Prompt exactly how you like your SQL, and add your own code
    snippets to the customizable library</p>
  </blockquote>