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

Home -> Community -> Usenet -> c.d.o.server -> String function

String function

From: Max <massimo.panero_at_ideainformatica.org>
Date: Tue, 26 Aug 2003 10:46:57 +0200
Message-ID: <bifarn$8hvkb$1@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 - 03:46:57 CDT

Original text of this message

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