SQL Query Number of particular letter in a word

select length('Bibekananda')-length(replace('Bibekananda','a','')) from dual;