<div>
Since the third parameter of regexp_replace defaults to null, you can further simplify mrjoltcola's expression to<br />
select length(regexp_replace('aab<wbr />bbaccc', '[^a]')) from dual;<br />

</div>


Since the third parameter of regexp_replace defaults to null, you can further simplify mrjoltcola's expression to
select length(regexp_replace('aabbbaccc', '[^a]')) from dual;


<div>
<div class="content wysiwyg-content">
<br />
I have a string 'aabbbccc''<br />
<br />
Now, I wanted to find out how many 'a' are there in this string.. Can someone guide me? <br />
<br />
Quick response is appreciated!
</div>
</div>



I have a string 'aabbbccc''

Now, I wanted to find out how many 'a' are there in this string.. Can someone guide me? 

Quick response is appreciated!

No. of occurences in oracle

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.