<div>
<div class="content wysiwyg-content">
Hello All<br />
<br />
I need a oracle query to count the occurrence of |~| <br />
<br />
I have<br />
Row1 &nbsp; &nbsp; Row2<br />
1222 &nbsp; &nbsp; &nbsp;f|~| d<br />
1223 &nbsp; &nbsp; &nbsp;f|~| df|~| df|~| d.f|~| d<br />
<br />
I would like to get<br />
<br />
1222 &nbsp; &nbsp; 1<br />
1223 &nbsp; &nbsp; 4
</div>
</div>


Hello All

I need a oracle query to count the occurrence of |~| 

I have
Row1     Row2
1222      f|~| d
1223      f|~| df|~| df|~| d.f|~| d

I would like to get

1222     1
1223     4

count the occurrence of|~|

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.