Re: need help with Oracle (for a query)

"Limner" wrote (as he did in c.d.o.misc.)...
>
>
> Hi to all
>
> i've a question.
> I need to know how to count how many times it present a particular
caracter
> in a varchar2 field ( i've oracle 9i )
>
> For example: " Pippo|pluto|paperino" and i want to know how many
times
> is present the caracter "|" ( 2 times )
>
> can someone help me in this ??
>
> Thanks in advance
>
> Danilo
>

Danilo,

since you post in c.d.o.tools you are in a pl/sql environment. Just perform a loop using SUBSTR() and count the hits.

hth,
Guido Received on Mon May 05 2003 - 13:35:52 CEST