title: Finding the count of characters and numbers in a string
body: <p>Hi I have a table test as below</p>
  
  <pre><code>NAME
  ---------
  abc1234
  XYZ12789
  a12X8b78Y9c5Z
  </code></pre>
  
  <p>I try to find out the count of number of numbers and characters in the string as</p>
  
  <pre><code>select name,length(replace(translate(lower(name),'abcdefghijklmnopqrstuvwxyz',' '),'      ','')) as num_count,
  length(replace(translate(name,'1234567890',' '),' ','')) as char_count
  from test6;
  </code></pre>
  
  <p>Its executing fine giving the output </p>
  
  <pre><code>NAME    NUM_COUNT   CHAR_COUNT
  abc1234         4       3
  XYZ12789        5       3
  a12X8b78Y9c5Z   7       6
  </code></pre>
  
  <p>But my question is there any option by not giving the <code>abcdefghijklmnopqrstuvwxyz</code>
  and <code>1234567890</code> manually </p>