Hi everybody,
Can anybody help me out with the pattern matching program in oracle using PL/SQL.
Like, for example the input is : Assassins and the pattern is : ass, the output should be : 2 (i.e.,) it should show me the number of times the pattern is repeated. Try and please do reply me as soon as possible.

Thank you.

REGEXP_COUNT (if you are on 11g).

I *think* that, reading through forums, I saw that Oracle Text is capable of doing that. I didn't use Oracle Text so I can't speak from my own experience, but Oracle Text CONTAINS Query Operators might be of use (DEFINESCORE, using OCCURRENCE(COUNT)).

Pure PL/SQL? Write a program.

hei,
I was actually browsin thru the net whole of yesterday and got an answer which goes like this...
select regexp_count('Assassins','ass',1) from dual;
Output : 2
the first parameter is the string passed, the next is the pattern to be found and the last parameter is the starting point from where you want the matching to be done...

Thank you, LittleFoot.. Infact i didnt see your answer.. thanks a lot dude