title: Count number of vowels in a word and generate a report summary using SQL in Oracle
body: <p>I have a requirement to count number of vowels in a word. Is it possible to do it in SQL? I can easily implement it using a function(PL/SQL).</p>
  <p>But I want it to be done in SQL.</p>
  <p>I have no clue about how to start. To enhance my requirement, it is not just vowels. Just to count whatever alphabets list given. also To display the the number of occurences as well.</p>
  <p><strong>Example</strong> : <code>STACKOVERFLOW</code></p>
  <pre><code>A 1
  E 1
  I 0
  O 2
  U 0
  </code></pre>
  <h2>Note on possible duplicate</h2>
  <p>The possible duplicate link you suggest just count the letters; in order to generate a report, that approach won't help! If you wish, please re-evaluate.</p>