Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: String parse help in Oracle
"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
![]() |
![]() |