Re: String parse help in Oracle

From: Digeratus 2006 <digeratus2006_at_nospam.hotmaildotcom>
Date: 08 Nov 2007 00:43:22 GMT
Message-ID: <Xns99E1CB48C2C7Edigeratus2006@63.218.45.20>

"CK" <c_kettenbach_at_hotmail.com> wrote in news:InnYi.1101$0Q5.1013_at_nlpi070.nbdc.sbc.com:

> How can I search a string supplied by a user for the first occurrence
> of a letter that is also supplied by a user; once you find the letter
> display its position within the string.
>
> Also I would like to modify the script above so that the string is
> searched for all occurrences of the letter. For each occurrence of
> the letter, display its position within the string.
>
> Thanks for any help or examples of how to do this.
>
> V/R,
> ck
>
>

Start with INSTR
INSTR (string , substring )
followed by repeated executions of
INSTR (string , substring , position )

See Oracle Documentation for more information http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/functions0 70.htm#i77598

Andy Young Received on Wed Nov 07 2007 - 18:43:22 CST