Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: best way to loop over string value character by character
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.
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
![]() |
![]() |