Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Mailing Lists -> Oracle-L -> Number of particular characters in a given string?

Number of particular characters in a given string?

From: Sami Seerangan <dba.orcl_at_gmail.com>
Date: Fri, 18 Feb 2005 13:54:19 -0500
Message-ID: <f09dd62805021810544917f90b@mail.gmail.com>

Is there any Oracle pre-defined fucntion to calculate number of given characters IN a given string?

For example, I want to know how many "O"s in string 'CORPORATE FLOOR'.

Thanks
Sami

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Feb 18 2005 - 15:56:32 CST

This message: [ Message body ]
Next message: Richard Ji: "Re: How to get timezone in 9i"
Previous message: Richard Ji: "Re: 66,000.00 times slower, please your opinion"
Next in thread: Rudy Zung: "RE: Number of particular characters in a given string?"
Maybe reply: Rudy Zung: "RE: Number of particular characters in a given string?"
Reply: rjamya: "Re: Number of particular characters in a given string?"

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US