need help with Oracle (for a query)

From: Limner <ATTENZIONEpend77_at_yahoo.itATTENZIONE>
Date: Mon, 05 May 2003 10:22:49 GMT
Message-ID: <ZXqta.91802$iy5.2854423_at_twister2.libero.it>

Hi to all

i've a question.
[Quoted] [Quoted] I need to know how to count how many times it present a particular caracter [Quoted] in a varchar2 field ( i've oracle 9i )

[Quoted] For example: " Pippo|pluto|paperino" and i want to know how many times [Quoted] is present the caracter "|" ( 2 times )

can someone help me in this ??

Thanks in advance

Danilo Received on Mon May 05 2003 - 12:22:49 CEST

This message: [ Message body ]
Next message: Guido Konsolke: "Re: need help with Oracle (for a query)"
Previous message: Mick A: "Re: Logon & stopping and starting processes on local machine"
Next in thread: Guido Konsolke: "Re: need help with Oracle (for a query)"
Reply: Guido Konsolke: "Re: need help with Oracle (for a query)"
Reply: Ray Tomilson: "Re: need help with Oracle (for a query)"
Reply: Sybrand Bakker: "Re: need help with Oracle (for a query)"
Maybe reply: Vijay: "Re: need help with Oracle (for a query)"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message