title: Get list of what special characters and how many times in oracle column
body: <p>I'm searching for a way to get a list of special characters and how many times they appear in my column.  I've tried using using regexp_count which works, but I'm not sure how to extend it to make it work for all special characters in one query.</p>
  
  <p>For example for syntax = 'x=y*100' with the following query I get</p>
  
  <pre><code>select *
    from (
           select regexp_count(syntax, '\*') as charCnt, syntax
             from tblTemp
         ) 
       where charCnt &gt; 0
  </code></pre>
  
  <p>charCnt=1 and syntax='x=y*100'.  </p>
  
  <p>Which is correct but I want to be able to get back</p>
  
  <pre><code>specChar Cnt
  
  \*       1
  =        1
  etc..
  </code></pre>