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 -> Re: String function

Re: String function

From: Michael Spellbrink <michaelspellbrink_at_yahoo.de>
Date: 26 Aug 2003 08:47:37 -0700
Message-ID: <638121fa.0308260747.628ad19@posting.google.com>


> ST := 'THIS IS A STRING';
> N := XFunction ( ST, 'S' ); // return 3
> N := XFunction ( ST, 'IS' ); // return 2
> N := XFunction ( ST, 'X' ); // return 0

you may replace every part of the string that does not fit into your pattern with <null> and then use length() with the rest.

hth,

michael spellbrink Received on Tue Aug 26 2003 - 10:47:37 CDT

Original text of this message

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