title: How can I count the number of words in a string in Oracle?
body: <p>I'm trying to count how many words there are in a string in SQL.</p>
  
  <pre><code>Select  ("Hello To Oracle") from dual;
  </code></pre>
  
  <p>I want to show the number of words. In the given example it would be 3 words though there could be more than one space between words.</p>