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: best way to loop over string value character by character

Re: best way to loop over string value character by character

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 02 Sep 2005 16:31:19 -0700
Message-ID: <1125703831.912014@yasure>


Rene Nyffenegger wrote:
> On 2005-09-02, DA Morgan <damorgan_at_psoug.org> wrote:
>

>>steph wrote:
>>
>>>good point.
>>>for each character in the string i want to call a specific function
>>>that checks this character against a matrix. It returns a number which
>>>i handle seperately.
>>>br,
>>>stephan
>>
>>Are the strings of a constant or variable length?
>>
>>The lack of specific information makes it difficult to know if there
>>is an alternative solution.

>
>
> But then again, I fail to see how the existance or absence of
> a constant string length would make a difference.
>
> Rene

I obviously do. ;-)

Faced a problem similar to this a few years back. Turned out all strings were of constant length and we were able to use DECODES to, in one pass, solve the entire problem. So I was checking just in case the same solution would work.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Fri Sep 02 2005 - 18:31:19 CDT

Original text of this message

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