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