title: Count how many times distinct words appear in a column Oracle 12c SQL
body: <p>How can you count how many times all the distinct words in a column appear</p>
  <p>Below is an example and expected output</p>
  <pre><code>+--------+------------------------------+
  | PERIOD |            STRING            |
  +--------+------------------------------+
  |        |                              |
  | 1      | this is some text            |
  |        |                              |
  | 2      | more text                    |
  |        |                              |
  | 3      | this could be some more text |
  +--------+------------------------------+
  
  +-------+-------+
  | WORD  | COUNT |
  +-------+-------+
  |       |       |
  | this  | 2     |
  |       |       |
  | is    | 1     |
  |       |       |
  | some  | 2     |
  |       |       |
  | text  | 3     |
  |       |       |
  | more  | 2     |
  |       |       |
  | could | 1     |
  |       |       |
  | be    | 1     |
  +-------+-------+
  </code></pre>
  <p>Thanks,</p>