Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: function count number of time a string appear in another string...
os2 wrote:
> hi
>
> how to do a function in pl/sql who will count the number of time a
> string appear in another string?
>
> thanks
Use intring inside of a loop. And with a little thought about how a B*Tree works it can be done with reasonable ease.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Wed Mar 03 2004 - 16:46:02 CST