Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> character count in a string

character count in a string

From: Eitan M <no_spam_please_at_nospam_please.com>
Date: Tue, 23 Jan 2007 16:37:27 +0200
Message-ID: <ep56kg$dco$1@news2.netvision.net.il> 





Hello,


how can I get a specific character count in a string
(


i.e : string is 56222, and I am looking for '2' occurance
when i do :


select charcount('56222') should return : 3
)



Thanks :) 
Received on Tue Jan 23 2007 - 08:37:27 CST












Original text of this message













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