Hi All..

How can i find the number of placeholder bind value occurances in a given query using regular expressions?

for example
: if the query is like ..
select * from EMP where EMPNO='&eno' and DEPTNO='&dno' --- [ it contains 2 occurances of bind values ]
select * from EMP where EMPNO='&eno' --- [ it contains 1 occurance of bind value ]

so the regular expression should return the count of occurances.

Could anyone help me out in this regard ?

Thanks in advance.

Warm Regards,
Saravanan