Combine length and translate
SQL>
SQL> select length(
2 translate('how many consonants are there?',
3 'bcdfghjklmnpqrstvwxzaeiouy? ',
4 'bcdfghjklmnpqrstvwxz')
5 ) "# of consonants"
6 from dual
7 /
# of consonants
---------------
15
1 row selected.
SQL>
SQL> --
Related examples in the same category