Qry to find no. of occurance of a character in a string

Is there any way to find the number of occurance of a given letter in a string through SQL query? If so, plz help.

-Raja.M

length(my_string)-Nvl(length(replace(my_string,'X')),0)