title: Count words in a database column
body: <p>Let's say I have a table <code>shortText</code>:</p>
  
  <pre><code>ID    | SHORT_TEXT
  ------+---------------------------
  001   | The elephants went in two by two
  002   | Needles and haystack
  003   | Somewhere over the rainbow
  ...
  </code></pre>
  
  <p>How to query <code>shortText</code> to Count the occurence of each word in column <code>SHORT_TEXT</code> (without using a stored procedure) to get a result like </p>
  
  <pre><code>WORD  | OCCURENCE
  ------+------------
  the   | 2
  and   | 1
  over  | 1
  ...
  </code></pre>
  
  <p>Edit: </p>
  
  <p>There is no general answer (variable number of words without a given maximum) provided so far in SO.</p>