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

If you potentially want to look at each and every column position of a variable then using substr in a loop is pretty much the only way in pl/sql since there is no pointer datatype.

Several of the provided string functions can perform variable column scanning operations such as instr which can identify the column location where specified conditions are true.

Through use of the substr, instr, replace, transform, and the length functions you can manipulate character values pretty much as needed.

HTH -- Mark D Powell -- Received on Fri Sep 02 2005 - 08:20:06 CDT