Mega Code Archive

 

Categories / Oracle PLSQL / Char Functions

 

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> --