Re: String function

There is no Oracle function giving you this directly, but it will be very easy for you to create it with "instr". Look it up in the docs.

Daniel

"Max" <massimo.panero_at_ideainformatica.org> wrote in message news:<bifarn$8hvkb$1_at_ID-121437.news.uni-berlin.de>...
> Is there a function that return how many occurrence of a substring are in a
> string?
> Or how can i do by myself?
> Example:
> ST := 'THIS IS A STRING';
> N := XFunction ( ST, 'S' ); // return 3
> N := XFunction ( ST, 'IS' ); // return 2
> N := XFunction ( ST, 'X' ); // return 0
Received on Tue Aug 26 2003 - 08:54:52 CDT